Hi, The main hurdle to changing to another DB type is me. I am still developing portions of the app, and it is taking a looooong time. Thus any learning curve for me(aka much extra time), would be a very bad choice.
They have only just setup the Server, and the person doing it is kind of new to that. Is it not possible that there is some setting that is not yet made, or some setting that could be made ? Rob, [EMAIL PROTECTED] ----- Original Message ----- From: "Adelle Hartley" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Sunday, April 17, 2005 1:01 PM Subject: RE: [vbhelp] Re: MDB on Server Goes to Sleep after a few minutes Hi, > 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 ? If your database is only 10MB and file caching were already working, then the whole file should already be cached (or at least there is no reason why any of it would drop out of the cache once loaded). > 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. I would consider using MSDE. It is a good solution for <10 users and if it solves your problem, then your boss will be more inclined to invest in a full blown SQL Server license should the number of users grow. I would be inclined to investigate the cost of a "development license" for SQL Server - the SQL Server tools will make developing and maintaining an MSDE database a lot easier (and for your employer, cheaper) and you can deploy the finished product using MSDE (which will cost nothing, since it is covered by your VB6 license [1]). > 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. Not such a bad strategy with Jet/Access. Unnecessary if you upgrade to MSDE. In the short term, I would try experimenting with continuous connections - but only if your updates are already wrappend in transactions (which should eliminate or at least reduce the risk of any corruption). Adelle. [1] Nothing in this e-mail should be construed as legal advice. I am not a lawyer. ---------- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.9 - Release Date: 13/04/2005 [Non-text portions of this message have been removed] '// ======================================================= 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/
