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 size (in MB, not records), because the whole
database file has to be scanned (and therefore to be loaded from disk).
In this case - if indexing is not feasable - you may want to consider
to split up the table into the small, heavily used and big, seldomly
used columns into two tables and join them as required. This will
reduce the amount of data read from disk.
Bye,
Benjamin.
PS: Btw, 168 columns sound like a strange table design...
On Fri, Jun 15, 2001 at 05:51:11PM -0600, [EMAIL PROTECTED] wrote:
> 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 -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 are 168 columns. A query like 'SELECT 97TotalAssets,
> 98TotalAssets FROM Business WHERE SIC='112'' will take a good 5 seconds.
> Any more useful of a query will take up to 90 seconds. All the queries are
> SELECT's.
>
> Is there something I can do, or am I going to need something faster than a
> 166?
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
