Hi -
My short question is: do subqueries use the query cache in
mysql?
The long version:
I am writing a php application that involves google maps -
basically,
it performs a fulltext search on some data, and then
restricts the
output to a certain latitutude and longitude, as the user
drags the map
around. Obviously, the slowest part of the query is doing
the fulltext
search. What I would like to do is cache the ouput of the
fulltext
search, so i only have to do it once - then, as the user
drags the map
around, the db would only have to perform the lat and long
restrictions
on the cached data.
I had hoped that by putting the fulltext portion into a
subquery, that
portion would be cached - but it seems that that is not
working. I'm
wondering if there's some setting i ought to tweak, or if
it is even
possible to cache subqueries. If not, does anyone have input
on whether
it would be faster to break the query into two completely
separate
queries (i.e. do the fulltext search first, return ids to
php, and then
perform a separate query based on those ids to restrict lats
and
longs). I am using mysql 4.1 on debian - i am not opposed
to upgrading
to 5.1 if it helps.
Thanks for any insight folks can offer.
--greg
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "PHP & MySQL" group.
To post to this group, send email to phpmysql googlegroups.com
To unsubscribe from this group, send email to
phpmysql-unsubscribegooglegroups.com
For more options, visit this group at http://groups
.google.com/group/phpmysql
-~----------~----~----~----~------~----~------~--~---
|