|
|
Posted by seaside on 01/13/08 13:30
On 13 Jan., 07:42, IanRear...@gmail.com wrote:
>
> I've optimized my queries, total mysql query time is about .1 to .12
> seconds total.
Although mySQL takes just a few seconds, did you use an index for
attributes
in WHERE clauses?
Additionally, MySQL disables its cache by default. You need to enable
it
manually to make MySQL return cached result sets.
Moreover, note that MySQL only assumes queries to be identical, if
they are textually identical. Even a a single added space make MySQL
compute the query again and no use the cache.
Navigation:
[Reply to this message]
|