List:General Discussion« Previous MessageNext Message »
From:Alexis Cheshire Date:December 7 2004 4:28pm
Subject:Query Cache
View as plain text  
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"]=1;
Array["data"][0][field1]=1;
Array["data"][0][field2]=2;
Etc...

//ELSE
//Would Output something like:
Array["status"]["cached"]=1;
Array["status"]["count"]=1;
Array["data"][0][field1]=1;
Array["data"][0][field2]=2;
Etc...

Any ideas would be greatly appreciated...

Skex


Thread
Query CacheAlexis Cheshire7 Dec
  • Re: Query CacheEric Bergen7 Dec
RE: Query CacheAlexis Cheshire7 Dec
  • Re: Query CacheEric Bergen7 Dec
RE: Query CacheAlexis Cheshire7 Dec