Hi Richard
> I have a fairly complex query that runs against 3 MySQL tables to > produce a list of contacts that are used to populate a select list. > The select list may need to be rebuilt a number of times as the user > refines their search. The query won’t vary and the likelihood that the > results will vary are low enough that saving the results in a session > variable is acceptable. I’d expect that the user would peruse the > results for 10 to 60 seconds before refining their search. What do you mean, "the query won't vary?" Surely, everytime the user refines the search, the query changes. Doesn't it? > My question is: should I save the query results in a session variable > for reuse or is the database efficient enough to cache the query results? > > > > Thanks and regards > > > > Richard > > -- > NZ PHP Users Group: http://groups.google.com/group/nzphpug > To post, send email to [email protected] > To unsubscribe, send email to > [email protected] > > -- > NZ PHP Users Group: http://groups.google.com/group/nzphpug > To post, send email to [email protected] > To unsubscribe, send email to > [email protected] -- NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected]
