>>>When I run a query "SELECT count(*) as count FROM tbl where col_1 like
'value1'", the query can take up to 45 minutes to bring back a result if
there are
>>>large number (sometimes 1 million plus) of records that match 'value 1'.
Use EXPLAIN to make sure that you're using an index that you h
I'm trying to get a handle on how an increase inf physical memory will
affect the query time for a large table. Here's the set up.
I'm running MySQL 3.23.37 on RedHat 6.0.
The server has a 700Mhz process with 1.5 Gig of RAM.
I'm querying a table with 47 million plus records that has 3 columns (
