7 years ago
1
Topic

Hello


On a quite moderate J3.6.5 +seblod 3.10 website (100 000 contents or so) each article recording takes about 15 seconds! 

Other sites on the same server with the same j! +seblod versions don't show these problems. First I believed the assets table had issues so we cleaned it with ACL Manager

Now I can't find anything that could really cause delays in the assets table. I'm also in doubt if it is caused by the assets table. When I enable the Joomla debug mode I see that the "afterRenderComponent com_content" function causes most delay. 


So I think that the large data set (possible also in relation to the CCK) is causing the delay, and not specifically the assets table.

Any idea please ?

thanks

cyril

Get a Book for SEBLOD
4229 Posts
Kadministrator
7 years ago
0
Level 1

As it happens on insert it is probably database issue, you will need to use real profiling tool like Xdebug + Kcachegrind or similar to pinpoint the problem on php side. for database side you need to enable slow query logging

https://www.sitepoint.com/optimizing-mysql-bottlenecks/

Get a Book for SEBLOD