Hi, I have a table that has nearly 3 million rows in it.
Its on a MySql db.
When i query from it simply SELECT * FROM TABLE
it takes about 4-5 mins for it to return the results for me.
I am using this table within another larger query, and the time to run the query has exceeded 12 hours! which i think is far to much.
I believe its to do with this table.
I have tried to Optimize the table by de fragmenting it.
i have also tried creating another table from it (which i suppose is similar to the above)
but it still takes a long time to query it.
Can anyone suggest what i can do to help speed up performance on this table?