CS Cart... abusive CPU usage! Why?

Store Builder Questions
21

[quote name=‘AmitP’]scuse my ignorance but how to change to static/dynamic menu system?[/quote]



Content → Blocks → All Pages → Find “categories” → Edit → Layout → “dynamic” → Save → Send Beer:mrgreen:

22

Magento: Crazy CPU usage

CS-CART: Crazy MySQL usage





Somebody has to optimize the database tables and database calls in cs-cart.

23

okay, sorry dude, i have now lost all my catagories? :S



im guessing you also meant

Design → Blocks → All Pages → Find “categories” → Edit → Layout → “dynamic” → Save → Send Beer

24

[quote name=‘AmitP’]okay, sorry dude, i have now lost all my catagories? :S



im guessing you also meant

Design → Blocks → All Pages → Find “categories” → Edit → Layout → “dynamic” → Save → Send Beer[/quote]



Correct…

25

[quote name=‘JesseLeeStringer’]Correct…[/QUOTE]



As I checked again, it already Filling by dynamic. Maybe need to consider switch to ajax menu.

26

I think my computer went bonkers with SEO addon turned on.





With SEO:


```php

  • Queries time: 0.0803



    After init
  • Memory: 959,320
  • Files: 52
  • Queries: 12



    Before TPL
  • Memory: 1,443,096 (2,402,416)
  • Files: 26 (78)
  • Queries: 139 (151)
  • Time: 0.0981 (0.0981)



    After TPL
  • Memory: 490,920 (2,893,336)
  • Files: 60 (138)
  • Queries: 98 (249)
  • Time: 0.1366 (0.2347)

    ```





    With SEO uninstalled:


```php

  • Queries time: 0.0820



    After init
  • Memory: 1,000,968
  • Files: 56
  • Queries: 14



    Before TPL
  • Memory: 1,454,504 (2,455,472)
  • Files: 25 (81)
  • Queries: 139 (153)
  • Time: 0.0671 (0.0671)



    After TPL
  • Memory: 659,080 (3,114,552)
  • Files: 61 (142)
  • Queries: 289 (442)
  • Time: 0.1748 (0.2419)

    ```





    98 queries compared to 289 queries with SEO addon turned on.





    Question is, why isn’t SEO queries cached?



    Not a good idea hitting the SQL database so many times on one page load.