[Typo3] Page loads greater than 50 secs involving table cache_hash

[Ries van Twisk]

Paul,

at least it would be a good idea to make a diff and put it into 
bugtracker (if it's not in there)
There are mor mysql issues that need to be solved... Currently I have 
page times of arounf 10 sec...
I am currently looking for a PHP profiler to see where my times are 
exactly go to...

ries

>Hi,
>
>I seem to have a rather strange problem which I have been wrestling with
>for about 3 weeks when using typo3.6.1 and mysql 4.1.0. Any page load on
>my site is taking about 50 secs according to microtime(). This evening I
>think I have pinned it down to select statements involving the table
>cache_hash as individually they are taking about 12 seconds. Other sql
>statements not involving this table are fast.  I have no idea why this is,
>as the same sql statement from the command line takes milliseconds.
>Strangely, though, if I apply debug by setting error=1 (line 792 of
>t3lib/class.t3lib_db.php and var $debugOutput = TRUE (line 135 of the same
>file) I can see that the statement is woring i.e it is able to "select
>content from cache_hash where hash = "...." .
>
>I can only think it may be something to do with the need for back ticks
>wherever the column name "hash" is used as this is a reserved word in
>mysql 4. For this reason I had to change files
>class.t3lib_page.php, class.t3lib_db.php, class.t3lib_install.php,
>class.t3lib_befunc.php modifying any column reference hash to `hash` in
>order not to receive mysql errors both during installation and normal
>running. Even though the errors have stopped I can only think the problem
>lays in this area.
>
>Any help most appreciated as I have pretty much run out of ideas
>
>Thanks
>Paul
>
>
>_______________________________________________
>Typo3-english mailing list
>Typo3-english at lists.netfielders.de
>http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>  
>


-- 
R. van Twisk
http://www.metamorf.net

Our Typo3 enabled website: http://www.livetravelguides.com
Instand help for Typo3?    irc:/irc.freenode.net/typo3
Looking for documentation? http://typo3.org/documentation/