Hi.
Do you have an index SIC? If so, I don't know any reason which would
explain such a slow server for such a simple query (on a table with
only 9.000 records), no matter what the configuration is.
If SIC is one of those unidexed decimals, the speed may be expected,
depending on the database si
On Fri, Jun 15, 2001 at 05:51:11PM -0600, Chris Cameron wrote:
>
> I compiled MySQL 3.23.37 myself with -O6's -march-i586 and various
> ./configure options I don't remeber. The database I'm using has 3
> tables of about 9 thousand entries, un-indexed decimal(5,8)'s, and a
> few tinytext's. There
