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] ----------------------------------------------------- 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/
