Not too familiar with databases myself, but it still seems a very small database if it's just 30 MB in size. It's more the number of records that seems to slow it down. It seems to me that it will still be slow when you move it over to another database system. An upgrade to Delphi 2006 will probably mean that you will have to do a major rewrite. A lot of changes have been made and although Delphi is backwards compatible, you might have lots of problems with any third-party components. One more thing... It's growing by 12.000 records per week and now has 600.000 records already? So am I right in assuming you're using it for about 50 weeks now? With about 100 bytes per record? It doesn't seem like a lot of information per record to me. No indices? Not sure about what you are storing in this database but considering the amount of records and the size per record it seems that you need something better optimized for storing large amounts of small records. If your index is just an integer and all you need to do is search on this index, then using a Delphi flat file might give it a huge prformance boost. :) But you probably need to search on more than an index number. Sorry, but I'm not that advanced to give advise about databases...
Greetings, Lisa. --- In [email protected], "Dave Murray" <[EMAIL PROTECTED]> 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] > ----------------------------------------------------- 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/
