Large Table performance

chillinmoon · #1 (**permalink**) 10-15-03, 05:46

Hi,
I have a large MyIsam table with 15 NUmeric fields and 3 BigText fields. When the data grows over 500000 rows, select performance goes down rapidly to over 90 seconds. What options do I have to speed up the select operation. Will InnoDB be better than MyIsam?

Regards,
Ash

bstjean · #2 (**permalink**) 10-15-03, 10:36

Quote:

Originally posted by chillinmoon
Hi,
I have a large MyIsam table with 15 NUmeric fields and 3 BigText fields. When the data grows over 500000 rows, select performance goes down rapidly to over 90 seconds. What options do I have to speed up the select operation. Will InnoDB be better than MyIsam?

Regards,
Ash

Can you be more specific? Do you have an EXPLAIN for the problematic queries and a DESCRIBE of the involved tables and a SHOW INDEX?

Internet Services

Web Development

Digital Marketing

Consumer Tech