Infinity wrote on Aug 18
th, 2006 at 4:09pm:
* I will eventually be importing my records from Q&A into these databases. Of course, not every field will make the jump, as a sh*tload of stuff has been eliminated (ghost fields, fields that held programming, etc). How will the influx of stored data effect the compiling time? Does it matter, or is Sesame looking at programming only when it compiles?
The number of records makes no difference to compile time. You can usually reduce compile time through the use of functions and subroutines. At any rate, keep in mind that each Form only compiles once per mode per session. Once someone opens the Form in add mode, as long as they don't close the application, the next time they open that Form in add mode, it will not need to recompile.
Quote:* When the application moves to the server, will compiling be done there or at the client? Which is better, a faster server or a faster client? (Most of my current workstations are newer, faster machines than my server.)
SBasic runs and compiles on the Client.
BTW, SBasic is one of the only things that happens on the Client. If you have lots of users or big databases, at least give your server a healthy dose of RAM.