Caching of feeds in Rapido

Adrian Ursu

Posted on 18/03/2019 10:57:51

Hi guys,

I have a project where I see unusual delays in loading of the feeds for product lists. it might happen to other feeds as well, but this one seems to be noticeably slow.

I am talking about something like this: https://www.allmedia.sk/produkty/mechanicke-kotvy?feed=true&DoNotShowVariantsAsSingleProducts=True

The feed seems to load between 6 sec to 12 seconds. I am talking about anonymous users, no assortments but with variants.

I understand the caching of this feed for Authenticated users is not applicable because of the stock and/or pricing but for anonymous users, it should be possible to cache it somehow.

Is there a way I can accomplish this caching? or speed up the load time?

The webserver does not seem to be overloaded while doing these tests (CPU usage is between 5 and 25%), therefore I am not considering adding more resources. The webserver hosts both the IIS and the SQL server, which should also improve the connection to the database.

I have checked the indexes for defragmentation but I am out of ideas.

Does anybody have any suggestion?

Thank you,

Adrian

Replies

Nicolai Pedersen

Posted on 18/03/2019 15:20:23

Hi Adrian

You can look at it here:

https://www.allmedia.sk/produkty/mechanicke-kotvy?feed=true&DoNotShowVariantsAsSingleProducts=True

You have a lot of variants - and eventhough you have not configured Rapido to show them, the feed loads all that variant data even though you do not need it.

So I would get rid of the variants in the feed template and also upgrade to latest 9.5 (or maybe 9.6) since that would get rid of the loop to EcomDetails.

BR Nicolai

Adrian Ursu

Posted on 18/03/2019 15:55:15

Hi Nicolai,

Thank you.
Apparently, the problem was generated, again, by Live integration code. There are 2 notifications that we had to disable: PageOnGlobalTagsObserver si PageOnLoadObserver

These notifications are running even for anonymous users, causing important delays.

After deactivating them, the load time (including variants) went down to 750 ms which I think it is acceptable considering the number of variants.

I am not sure I can get rid of the variants since the Product Detail page needs them for loading the Product detail variants list. Maybe I can make a separate one just for variants.

I am planning on upgrading to the latest 9.5 (we already have the dev site testing it) and later on to 9.6.

Thank you,

Adrian

Nicolai Pedersen

Posted on 18/03/2019 16:04:40

I think you can get rid of variants in the list feed template - as the product detail template uses another feed.

BR Nicolai

Mikkel Ulstrup

Posted on 18/06/2019 22:27:00

Hi,

The loop to EcomDetails seems to have been re-implemented in 9.6.. We get 39 SQL queries selecting from the table on a page with 7 products.

Any chance this was a mistake? or do we have to avoid this in some other way?

Kind regards

Mikkel Ulstrup

Nicolai Pedersen

Posted on 18/06/2019 22:29:09

This is a mistake... We are also working on a solution with issue today, so we will re-fix this again.

Sorry about the inconvenience

Mikkel Ulstrup

Posted on 18/06/2019 23:07:31

Thank you for the quick response! We are looking forward to it :)

- Mikkel

Andrew Rushworth

Posted on 10/07/2024 16:53:45

Hi All,

I'm also experiencing slow product feeds. I've stripped down the feed, excluding variants, etc - size is now 222k from 700k, but the feed still takes long to run 8-10s.
https://www.arcstore.co.za/arc-sale-july-2024?feed=true&DoNotShowVariantsAsSingleProducts=True

running version 9.5.13

Any ideas on how to improve this?

Thanks,
Andrew

You must be logged in to post in the forum

Developer forum

Caching of feeds in Rapido

Replies