[TYPO3-dev] mysql/mysqli and prepared statements

[ries van Twisk]

Hey Martin,

I have reading somewhere that when using
MySQL with prepared statements that the query cache
get's by-passed.

For is this will result in lower performance since
TYPO3 can benefit quite a bit from this.

If this is true, then I am not sure if prepared statements is
the right way to go on MySQL to increase performance.

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?

Just my 2 cents for now....

Ries







On Oct 6, 2007, at 4:07 PM, Martin Kutschker wrote:

> Hi!
>
> Shall TYPO3 provide means to use the mysqli-driver and get support for
> prepared statements? I say yes. There are places in the Core where the
> "same" statement is called within a loop.
>
> Easiest way: make a "mysqli" sysext which gets installed automatically
> if the installer finds mysqli is loaded.
>
> ALternative way: make t3lib_div::makeInstance factory aware. That  
> means
> it should see if the class in question has a factory method and call
> that. Add a factory to trlib_db that returns an instance of
> t3lib_db_mysqli if the PHP extension is loaded.
>
> Masi
> _______________________________________________
> TYPO3-dev mailing list
> TYPO3-dev at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev

--
Ries van Twisk
Freelance TYPO3 Developer
email: ries at vantwisk.nl
web:   http://www.rvantwisk.nl/
skype: callto://r.vantwisk
Phone: + 1 810-476-4193