RE: Query Cache

2004-12-07 Thread Alexis Cheshire
t has been returned from the Cache rather than the Direct from Raw Tables. Hope that is a bit clearer Cheers Skex -Original Message- From: Eric Bergen [mailto:[EMAIL PROTECTED] Sent: 07 December 2004 17:30 To: Alexis Cheshire Cc: [EMAIL PROTECTED] Subject: Re: Query Cache 'show'

RE: Query Cache

2004-12-07 Thread Alexis Cheshire
Do you know if this is available thru the C API .. Could a User Defined Function be written to return this? Any more ideas would be great.. Thanks Skex -Original Message- From: Eric Bergen [mailto:[EMAIL PROTECTED] Sent: 07 December 2004 16:50 To: Alexis Cheshire Cc: [EMAIL PROTECTED

Query Cache

2004-12-07 Thread Alexis Cheshire
Hi, Is there a way to access if a Query is returning its record from QUERY_CACHE or not? E.g. $sql="SELECT * FROM TABLE"; $result=db_query($sql); print $result; //If query NoT returned from mysql_query_cache() //Would Output something like: Array["status"]["cached"]=0; Array["status"]["count"]

Help with SLOW query

2004-11-08 Thread Alexis Cheshire
Help: (and apologies if this is posted to the wrong list..)(pls let me know where to post if so.. Thx ;-) I have *inherited* an App that uses PHP / MySQL. THe internal search function within the application that I am supporting uses the following DB Table structure and runs the Query below to r