Dave, >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? >
The Access mdb file has a maximum size limit that is fairly confining for most non-trivial DBMS projects. You would also want to consider that. As far as the query performance, I would first evaluate whether your query is reverting to a table scan. In other words, do your tables have indexes which allow the query optimizer to make use of an index instead of looking through all the records in a table. If you need help evaluating this, send an example of a long running query along with a list of all the indexes defined for the table(s). Glenn Lawler ----------------------------------------------------- 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/
