Hi everyone,
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. 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]
