Hi,
All my previous DBs were Access 97 on single user pcs. The pgm I am developing at the moment is multi user. Each user has a copy of my VB6 pgm on their pc, and they all access a single Access(97) db on a central Server(Windows Server 2003). In my stand-alone pc pgms, I have always noticed that the first opening of an Access db takes a fair while, and for the rest of that Windows session you never get that delay again. (W98 and XP were both the same). I figure that Windows has a trick of loading some stuff into memory (or whatever), so that any subsequent calls to the DB are faster. With my new setup the users are noticing similar delays, any time they allow my pgm to be inactive for a few minutes. We have tested and noticed that the delay is not in the pgm itself, as it can still immediately react to a Form show etc. If they then do someting that requires a DB lookup, then the 'kick to wake up delay' is noticed. My conclusion is that their Windows cannot do it's little trick with the DB, as they have no control over what is happening on the server. My question is, is it possible to get the server to maintain the DB in whatever state(place in memory ? ?) it occupies when the user is interacting frequently ? If user keeps accessing the DB frequently, it somehow remains 'quick'. If they stop for say 4 minutes, then the next interaction is noticeably slower. Then it will be fast again as long as they keep kicking it every minute. I know (very)little about Servers, so no doubt the solution, is not the one I have 'pulled out of thin air'. EG Caching, having the db always in the Server's swap file, etc. Thanks for any help, Rob Crombie --- In [email protected], "Unicorn.PC.Support" <[EMAIL PROTECTED]> wrote: > Chris, SQL Server, or any other RDMS is not a magical pill that when you > drop them into your project Database problems solve themselves. '// ======================================================= 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/
