> > I have to keep all transactions in one table for our reporting and futher > > analysing and if some other customers need exports I just can create batch > > sripts which will export their data for their own processing. > > > > Thank you for your help and time and also thanks others which responded to > > my question. > > The best thing you can do is creating a bunch of test data. Use the flag. > Test it. Next, try other ways. Test it. > > Measuring is knowing. And take a look at the query plans involved.
<plug> btw, our tool "Database Workbench" has a neat "Test Data Generator" that can be used to create (semi) random data. Also, on our site: Advanced Data Generator (MySQL Editition). :-) </plug> With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
