[TYPO3-dev] mysql/mysqli and prepared statements

[Michael Stucki]

Hi Martin,

>> Note: since we use the unix timestamp the MySQL
>> query cache for SQL's we execute is valid for one
>> second anyways. Wasn't there a patch underway for this?
> 
> I don't get what you're hinting at.

See t3lib_pageSelect::enableFields():

SELECT * FROM tt_content WHERE 1=1 AND starttime<=$GLOBALS['SIM_EXEC_TIME']

Such a query will be different every(!) second. I never tested it but it
appears logical that this will make it impossible to use the query cache
for stuff like that...

- michael
-- 
Use a newsreader! Check out
http://typo3.org/community/mailing-lists/use-a-news-reader/