> > I have to keep all transactions in one table for our reporting and
> > analysing and if some other customers need exports I just can create
> > sripts which will export their data for their own processing.
> > Thank you for your help and time and also thanks others which responded
> > 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.
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).
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL