Spaces in Code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Should I edit all of my code to remove white spaces (empty lines) between
code to clean it up. Will this make db run more efficently or doesn't it
matter? Thanks.
 
The amount of difference in time is not going to be measurable. So, no...

Eventually, if you reach he point were you want to have the application
multi-user, or have other people use the application, and NOT be able to
modify things, the you can create what is called a "mde". This feature
compiles the code, and strips out all source code. So, those blank lines are
removed, and since no "runtime" compiling occurs, then you do see some
performance increase. However, the "speed" of processing today is usually
NEVER a problem (we have the speed of a 15 million dollar Cray from the mid
1980's on your desktop now). In fact, those were around 200 mega flogs..and
we see at least 5 times that on a desktop today.

Even ms-access can execute millions of commands in a second. So, if you
have 100 lines of code, and 20 of them are blank, you are not going to save
even save 1 million of a second here.

However, the mde does run a bit faster as they have no source code, and no
debugging code. And, no "blank no-ops" commands are executed to keep in sync
with the source code file.

You can create a mde by going tools->database utilities->create mde.

You can read about the benefits of using a mde in the following article of
mine on how to setup, and use ms-access in the muiti-user environment

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm
 
Thanks again Al. I looked up the help information on compiling which I plan
to do before I distribute. I shoudl have read up more before posting. Sorry.
Hope all is well (an warm) in Alberta!
 
Should I edit all of my code to remove white spaces (empty lines) between
code to clean it up. Will this make db run more efficently or doesn't it
matter? Thanks.
Click to expand...

Shouldn't matter. It might add a few dozen bytes to the size of the
source code (which is stored deep in the undocumented systems tables),
but it won't be included when the code is compiled.

John W. Vinson[MVP]
 
Thanks John!

John Vinson said:
Shouldn't matter. It might add a few dozen bytes to the size of the
source code (which is stored deep in the undocumented systems tables),
but it won't be included when the code is compiled.

John W. Vinson[MVP]
Click to expand...
 
Back
Top