Re: Query cache query

2003-08-18 Thread Jeremy Zawodny
On Mon, Aug 18, 2003 at 11:53:29AM -0700, Michael S. Fischer wrote: I'm using MySQL 4.0.13 for a web application, and one of my queries is sufficiently complex such that it might take several seconds to return the results to the user. I'd like to return a please wait page if the query is not

RE: Query cache query

2003-08-18 Thread Michael S. Fischer
Jeremy Zawodny writes: Perhaps you could tell us more about the queries that take too long. Maybe there are some things you can do to reduce that time? You don't want to go there. But because you do... :-) As far as I can tell, the queries are as optimized as they're going to get. I'm

Re: Query cache query

2003-08-18 Thread Jeremy Zawodny
On Mon, Aug 18, 2003 at 04:51:17PM -0700, Michael S. Fischer wrote: Jeremy Zawodny writes: Perhaps you could tell us more about the queries that take too long. Maybe there are some things you can do to reduce that time? You don't want to go there. But because you do... :-) Uh oh.