Developer forum

Forum » Integration » Website slow after integration (caching ?)

Website slow after integration (caching ?)

E-mail notifications
Gaetan Di Caro
Reply
Posted on 20/04/2016 08:49:10

Hi,

 

On one of our projects we're having some issues with website speed. After an products/groups integration is done (with index update), the first user to visit the website has quite a hard time : every new page displayed is very slow to load. One the page has been displayed once, it gets displayed fast again if a user goes back there. This leads me to think this is a caching issue, but I don't really know where to go from here.

Does it ring a bell for anyone ?

 

Thanks !

 


Replies

 
Nicolai Høeg Pedersen
Posted on 20/04/2016 10:15:06
Reply

DW is building up some caches on the first view of the product catalog. If you are using live integration that could also cause this.

But it requires a bit more looking into to tell. You can use debug=true and dbstat=true to get some insight to what takes the time on the pageviews.

NP

 
Gaetan Di Caro
Posted on 20/04/2016 13:07:38
Reply

Ok it seems that my product list page calls the SQL quite some, and these queries get cached after the first time.

Is there a way to generate the cache automatically ? I'm thinking of writing a bit of code in a JobFinished subscriber to simply call that page with an HttpWebRequest.

 
Nicolai Høeg Pedersen
Posted on 20/04/2016 13:14:16
Reply
This post has been marked as an answer

You can just execute the url that displays the product list inside your subscriber.

Votes for this answer: 1
 
Gaetan Di Caro
Posted on 21/04/2016 09:51:54
Reply

I did just that, it's working fine now :)

Thanks !

 

You must be logged in to post in the forum