Support » Plugin: Ultimate Product Catalog - WordPress Catalog Plugin » Performance issues with UPCP plugin

  • Hi there,
    In one of our applications, we are using this UPCP to show products on a page.
    In total, we have around 420 items and we are showing 15 items on the page.
    Navigating other products by using pagination.
    We noticed that on page load of this page, it is making nearly 5000 database calls which cause the page to be slow.
    We checked by adding/removing a product to catalogue and noticed, For a product, the UPCP plugin is making nearly 50 database calls.

    Is there a way to improve performance by reducing this DB calls?
    And we’ve already gone through older support forums –
    1. -> This doesn’t help us much

    We listed out all the queries to fetch and show one single product. You can find that queries list here –

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Contributor EtoileWebDesign


    Hi Sampath,

    In your queries list, there are many repetitive queries, such as item name, price, sale price, etc. This indicates that you are likely using all three catalog layouts (thumbnail, detail and list), as it calls that information for each one. If you exclude two of the three layouts, then you can eliminate those repeated queries and significantly reduce the overall number of queries.

    Thread Starter Sampath Kumar G


    Thanks for the suggestion.

    As per my requirement, I’ve to show both Thumbnail and Detail views on the page. I removed list view and it reduces nearly 150 database calls which doe’s not helped to improve the performance.

    Any further advice you can give that solves our problem, would be appreciated.

    My Suggestion:
    We can fix this by updating public_functions file to fetch the whole Item data, cache it and use whenever you want instead of making calls to the database every time to get the same item data again and again.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Performance issues with UPCP plugin’ is closed to new replies.