We use nop 1.9 version and our website is http://www.mark-ha.com
Everthing is fine but product details page.
Product details page opens soo slow (takes about 8 - 12 seconds to open)
For example category pages;
opens fast enough.
But the product pages;http://www.mark-ha.com/kom-jerom-sortlu-elbise-mayo
takes 8 - 12 seconds to open.
Every single category or manufacturer pages works quiet fast. Only the product details pages dont work well
If i shut the sql for 1 minute and re open again, everything works well but in couple of minutes it goes slow again.
This slow opening effect our cpu usage too. We consider that something wrong with the sql. perhaps sql connection is not closing or what so ever.
As we are running an e-business website (12000 products selling online) this speed issue effects our sales very badly and we need to solve this problem as soon as possible. We need any advice terribly.
Please do not hesitate to ask about more details.
Thank you in advance,