Thanks for response.
The pgm is going to be the most important software the company runs. It will be keeping track of all of their Leads(potential Jobs) and open jobs. Thus about 6 employees will have it running on their pc's all day, with interactions at various times during the day. There are drop lists, however the main table is the one that keeps the records for the Leads/Jobs(one table). Users will be connecting, loading a 'Job Register'(SGrid2), viewing individual Leads/Jobs, doing edits, etc, all mainly using that core Table. The data, I believe, is far too dynamic for any local 'storing'. The DB possibly will never exceed 10 MB, and proably will be much less. Could the whole DB be cached ? At the moment it is really annoying the boss (who is my design user), so I am sure that cost for extra memory on the server would not be a hurdle. Thanks again, Rob PS My design philosophy is - - Don't hold connections, just connect and read the data, and disconnect immediately. If the user has made changes to the Form, then I connect, update, and disconnect. My theory is that there is less chance of DB corruption if I do not maintain continuous connections. Mind you I have seen people proposing continuous connections, but I am hesitant to do that. --- In [email protected], "Adelle Hartley" <[EMAIL PROTECTED]> wrote: > Hi, > > File caching on the server would be less useful than on the client, unless > your server has enough memory allocated to file-caching to hold most of the > database. > > When local caching is involved, the cache will hold that part of the > database that the user last worked on. On a server with several users, > unless each user is consistently using the same part of the database as > every other user, the cache would be constantly being overwritten with > different parts of the file. > > Most of what I just said is guesswork. > > You should try to minimize the number of round-trips made to the database. > You should keep your own "cache" of relatively static, frequently used data, > used to populate drop-down lists. > > If you have a very small number of users, who are only hitting the database > occasionally, check that you do not have a screensaver on the server. > > HTH. > > Adelle. '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [email protected] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
