I'm a having a stange problem with mysql-nt on win2000.
Querys that last night were taking just 2 seconds are now taking 1m 30secs +.
I have a table...
Field Type Collation Null Key Default Extra Privileges Comment
------- ------------ ----------------- ------ ------ ---------- ------ ------------------------------- -------
H_ID int(10) NULL PRI 0 select,insert,update,references
H_Name varchar(255) latin1_swedish_ci YES MUL (NULL) select,insert,update,references
SireID int(10) NULL YES MUL (NULL) select,insert,update,references
GSireID int(10) NULL YES (NULL) select,insert,update,references
Gender varchar(50) latin1_swedish_ci YES (NULL) select,insert,update,references
DOB date NULL 0000-00-00 select,insert,update,references
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment
------ ---------- -------- ------------ ----------- --------- ----------- -------- ------ ------ ---------- -------
horses 0 PRIMARY 1 H_ID A 40926 (NULL) (NULL) BTREE
horses 0 h_name 1 H_Name A (NULL) (NULL) (NULL) YES BTREE
horses 1 SireID 1 SireID A 2273 (NULL) (NULL) YES BTREE
It has 40,000 recs.
When I run select * from horses, it takes 1m 40secs to get them.
anybody run in to this before? I'm considering reinstalling mysql. any toughts?
please help
Brian Power
_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
