Dave Murray wrote: > Hi, > > I've got a Delphi app that uses an Access database via BDE (Delphi 4 > so no ADO). At the moment there are about 600,000 records in the main > table and it is growing by about 12,000 - 15,000 records a week. The > database itself is currently over 30Mb in size. The app runs a lot of > queries against the main table and has been slowing down as it grows. > The speed is now getting to the point where the users are complaining. > > So am I reaching the limits of what I can do with an Access database? > Would I get a speed increase by switching to Delphi 2006 and using ADO? > Is it time to start looking at SQL Server? > > Thanks, > Dave. > > Dave Murray > Delphi-En Moderator > Glasgow, UK > [EMAIL PROTECTED]
The natural transition from MS Access is to either a non-Microsoft product (e.g. MySQL - I personally prefer this option) or to SQL Server Express (formerly known as MSDE) with a future transition to full blown SQL Server. If you go the MySQL route, there is a very nice tool called SQLyog that you will want to use to administer the database. -- Thomas Hruska CubicleSoft President Ph: 517-803-4197 Safe C++ Design Principles (First Edition) Learn how to write memory leak-free, secure, portable, and user-friendly software. Learn more and view a sample chapter: http://www.CubicleSoft.com/SafeCPPDesign/ ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> 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/
