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/
