Re: Caching Queries
Hi.
Are you sure that you ask in the right forum? Are your tables MEMORY tables?
Anyway, do you have proper indexes on your table? 500.000 rows does not say much about the size of the database. But if you measure times in minutes for that many rows, your statements probably don't use indexes. Most queries profit a lot from proper indexes.
Regards
Ingo
Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com
Subject
Views
Written By
Posted
4959
January 25, 2006 02:15PM
Re: Caching Queries
3675
January 26, 2006 04:45AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.