Lisa Westveld wrote: > 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.
Access doesn't perform well with any table over 100,000 records. The connection to the database alone takes at least 100ms (regardless of data) and queries take at least 50ms. MySQL can connect, run a simple query, and disconnect in under 10ms. From what you've said it sounds like you have a lot of INSERT queries. What is probably killing performance is the database locking mechanism (ACID). MySQL's InnoDB, while nice, will be just as bad performance-wise because it uses ACID. MySQL's MyISAM is a better approach, but you lose ACID (still has atomic locking for autonumber keys). MySQL also offers batch INSERT query executions (if you need to do more than one INSERT for a single table this can speed things up considerably). -- 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/
