[TYPO3-Performance] db-performance-issue

[Mathias Schreiber [TYPO3]]

Alberto Caso schrieb:
> Hi,
> 
> On Wed, 30-07-2008 at 14:54 +0200, Mathias Schreiber [TYPO3] wrote:
>> Freedom of choice.... hmm... I get your point, but if I am right we have 
>> like 20 DBAL installs compared to what... 20.000 MySQL Installs...
>> I go for "to heck with freedom" ;-)
> [...]
>> Set up a sitemap that has 300 pages displayed, enable realURL, get 
>> 18.000 (no kidding) database queries.
> 
> Then stored procedures may be of little help here and getting rid of the
> extra queries should be the first target.

t3lib_pageselect getRootline.
Nice idea trying to cache the requests that have already been made.
Unneccessary bug to clear the cache each loop.
Once I have more time I'll ask SVN who did this.

> Also, as Dmitry said, stored procedures could be abstracted through a
> set of classes that could call the SPs where available or use just plain
> SQL where not.

I don't think another abstraction layer would out-perform the gain of SPROC.

> DBAL is a good selling point (even when used only in a little percentaje
> of cases). Anyway, even in the case of just MySQL you could find users
> whose ISPs don't grant them enough privileges to create stored
> procedures.

This is a tough strategic decision...
If we are "enterprise", we may not care about crappy ISPs.
If we are "working on every 5 buck webspace", we're not enterprise.

Simple thing :)


-- 
T3A AM
Rocking TYPO3 since 3.1b1