From: Martijn Tonies
Date: March 31 2005 10:53am
Subject: Re: Index on boolean column
List-Archive: http://lists.mysql.com/mysql/181964
Message-Id: <029e01c535df$ee76f640$3802a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="ISO-8859-2"
Content-Transfer-Encoding: 7bit


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