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
I'm currently using a 166 UNIX machine for a dedicated MySQL database,
and I'm interested in knowing what kind of speed I should be expecting
from it. I ask because right now it's at a point of being unusable even
for development on some of the larger queries.
I compiled MySQL 3.23.37 myself with
