How could performance be improved of litecart 2.1.6?

Hello there

We are facing a performance problem with the Litecart 2.1.6 version. Does anyone have advice about how to improve the performance of this version litecart cms? 

We can't update the version of Litecart now. Just want some advice who has experienced with this version.

Thank you

Any version always had lightning speed.

Are you saying there has been performance problems with a fresh installation or a modified installation?

What is the cpu load on the machine, and how many products are in the database?

I think you need to check your hosting first. If you are saying that 2.1.6 is too slow I doubt you will feel better with newer version.

I've been running LiteCart mostly on cheap shared hosting without any issues for many years. There were only a couple servers that had extremely poor performance and also a couple of poor MySQL queries from my end that ended crashing the website.

Tell us more about your setup.

it is modified one.

CPU is normal now but sometimes it goes up to 60/80% when tasks more than 100

there is 1300 products

@dodo

I'm using ubuntu server

I would expect CPU usage to be 0-3 %.
1300 products is no issue.

Something is not right.

here is you can see tasks which uses high cpu and ram

performance log size increasing always. here is one of query.

It might be a reason? within 10-20 days it reached to 400mb

Warning: A MySQL query executed in 3.089 s. Query: update `litecart`.`shop_products`
    set views = views + 1
    where id = '5887'
    limit 1;
[2024-03-06 18:18:11 Europe/Stockholm] Warning: A MySQL query executed in 3.474 s. Query: select p.id as id ,pi.name as name ,pi.short_description as sdescr , ci.name as category, ci.short_description as category_desc , m.name as manufacturer , s.name as supplier
      from `litecart`.`shop_products` p  left join `litecart`.`shop_categories_info` ci on (ci.category_id = p.default_category_id and ci.language_code = "sv") left join `litecart`.`shop_manufacturers` m on (m.id = p.manufacturer_id) left join `litecart`.`shop_suppliers` s on (s.id = p.supplier_id)
      left join `litecart`.`shop_products_info` pi on (pi.product_id = p.id and pi.language_code = 'sv')
      where p.status = 1;
[2024-03-06 18:18:11 Europe/Stockholm] Warning: A MySQL query executed in 3.174 s. Query: select p.id as id ,pi.name as name ,pi.short_description as sdescr , ci.name as category, ci.short_description as category_desc , m.name as manufacturer , s.name as supplier
      from `litecart`.`shop_products` p  left join `litecart`.`shop_categories_info` ci on (ci.category_id = p.default_category_id and ci.language_code = "sv") left join `litecart`.`shop_manufacturers` m on (m.id = p.manufacturer_id) left join `litecart`.`shop_suppliers` s on (s.id = p.supplier_id)
      left join `litecart`.`shop_products_info` pi on (pi.product_id = p.id and pi.language_code = 'sv')
      where p.status = 1;
[2024-03-06 18:18:20 Europe/Stockholm] Warning: A MySQL query executed in 3.175 s. Query: select * from `litecart`.`shop_products`
            where id = 1701
            limit 1;
[2024-03-06 18:18:20 Europe/Stockholm] Warning: A MySQL query executed in 3.338 s. Query: update `litecart`.`shop_products`
    set views = views + 1
    where id = '41'
    limit 1;
[2024-03-06 18:18:20 Europe/Stockholm] Warning: A MySQL query executed in 3.621 s. Query:
      select p.*, pi.name, pi.short_description, m.id as manufacturer_id, m.name as manufacturer_name, pp.price, pc.campaign_price, if(pc.campaign_price, pc.campaign_price, pp.price) as final_price

      from (
        select p.id, p.code, p.sku, p.manufacturer_id, group_concat(ptc.category_id separator ',') as categories, p.keywords, p.product_groups, p.image, p.tax_class_id, p.quantity, p.views, p.purchases, p.date_created
        from `litecart`.`shop_products` p
        left join `litecart`.`shop_products_to_categories` ptc on (p.id = ptc.product_id)
        where p.status
          and (id

There is something wrong with your server. Updating a single product takes way too long.

I agree with tim and I don't think it's litecart issue. Check your server first.

So, I have a question. If in one page 150 products load each time customers open it. Would it be a reason for such a high load on the server?

If in one page 150 products load each time customers open it. Would it be a reason for such a high load on the server?

No

In fact your most simple queries that should take microseconds shows disturbance:

Warning: A MySQL query executed in 3.338 s. Query:
    update `litecart`.`shop_products`
    set views = views + 1
    where id = '5887'
    limit 1;

Try moving to another machine.
https://www.litecart.net/en/wiki/how_to_move_the_platform

got it, thanks