SEO addon - abusive database queries

Store Builder Questions
1

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





With SEO:


<br />
- Queries time: 0.0803<br />
<br />
After init<br />
- Memory: 959,320<br />
- Files: 52<br />
- Queries: 12<br />
<br />
Before TPL<br />
- Memory: 1,443,096 (2,402,416)<br />
- Files: 26 (78)<br />
- Queries: 139 (151)<br />
- Time: 0.0981 (0.0981)<br />
<br />
After TPL<br />
- Memory: 490,920 (2,893,336)<br />
- Files: 60 (138)<br />
- Queries: 98 (249)<br />
- Time: 0.1366 (0.2347)<br />

```<br />
<br />
<br />
With SEO uninstalled:<br />
<br />
```php
<br />
- Queries time: 0.0820<br />
<br />
After init<br />
- Memory: 1,000,968<br />
- Files: 56<br />
- Queries: 14<br />
<br />
Before TPL<br />
- Memory: 1,454,504 (2,455,472)<br />
- Files: 25 (81)<br />
- Queries: 139 (153)<br />
- Time: 0.0671 (0.0671)<br />
<br />
After TPL<br />
- Memory: 659,080 (3,114,552)<br />
- Files: 61 (142)<br />
- Queries: 289 (442)<br />
- Time: 0.1748 (0.2419)<br />

```<br />
<br />
<br />
98 queries compared to 289 queries with SEO addon turned on.<br />
<br />
<br />
Question is, why isn't SEO queries cached?<br />
<br />
Not a good idea hitting the SQL database so many times on one page load.
2

Another page:


```php

  • Queries time: 0.3618



    After init
  • Memory: 971,080
  • Files: 55
  • Queries: 16



    Before TPL
  • Memory: 10,239,192 (11,210,272)
  • Files: 30 (85)
  • Queries: 1031 (1047)
  • Time: 0.5387 (0.5387)



    After TPL
  • Memory: 858,744 (12,069,016)
  • Files: 56 (141)
  • Queries: 650 (1697)
  • Time: 1.1083 (1.6470)

    ```





    Seriously? 1031 queries on one page load?!!!





    Some samples:


0.00016 - SELECT name FROM cscart_seo_names WHERE object_id = 169 AND type = 'c' AND dispatch = '' AND lang_code = 'EN'
0.00017 - SELECT name FROM cscart_seo_names WHERE object_id = 187 AND type = 'c'
0.00015 - SELECT name FROM cscart_seo_names WHERE object_id = 187 AND type = 'c' AND dispatch = '' AND lang_code = 'EN'
0.00018 - SELECT name FROM cscart_seo_names WHERE object_id = 189 AND type = 'c'
0.00015 - SELECT name FROM cscart_seo_names WHERE object_id = 189 AND type = 'c' AND dispatch = '' AND lang_code = 'EN'
0.00018 - SELECT name FROM cscart_seo_names WHERE object_id = 190 AND type = 'c'
0.00015 - SELECT name FROM cscart_seo_names WHERE object_id = 190 AND type = 'c' AND dispatch = '' AND lang_code = 'EN'
0.00019 - SELECT name FROM cscart_seo_names WHERE object_id = 191 AND type = 'c'
0.00015 - SELECT name FROM cscart_seo_names WHERE object_id = 191 AND type = 'c' AND dispatch = '' AND lang_code = 'EN'
0.00017 - SELECT name FROM cscart_seo_names WHERE object_id = 192 AND type = 'c'
0.00016 - SELECT name FROM cscart_seo_names WHERE object_id = 192 AND type = 'c' AND dispatch = '' AND lang_code = 'EN'
0.00018 - SELECT name FROM cscart_seo_names WHERE object_id = 193 AND type = 'c'
0.00015 - SELECT name FROM cscart_seo_names WHERE object_id = 193 AND type = 'c' AND dispatch = '' AND lang_code = 'EN'
0.00019 - SELECT name FROM cscart_seo_names WHERE object_id = 218 AND type = 'c'
0.00015 - SELECT name FROM cscart_seo_names WHERE object_id = 218 AND type = 'c' AND dispatch = '' AND lang_code = 'EN'
0.00018 - SELECT name FROM cscart_seo_names WHERE object_id = 219 AND type = 'c'
0.00014 - SELECT name FROM cscart_seo_names WHERE object_id = 219 AND type = 'c' AND dispatch = '' AND lang_code = 'EN'
0.00018 - SELECT name FROM cscart_seo_names WHERE object_id = 226 AND type = 'c'
0.00016 - SELECT name FROM cscart_seo_names WHERE object_id = 226 AND type = 'c' AND dispatch = '' AND lang_code = 'EN'
0.00018 - SELECT name FROM cscart_seo_names WHERE object_id = 227 AND type = 'c'
0.00015 - SELECT name FROM cscart_seo_names WHERE object_id = 227 AND type = 'c' AND dispatch = '' AND lang_code = 'EN'
0.00019 - SELECT name FROM cscart_seo_names WHERE object_id = 228 AND type = 'c'
0.00015 - SELECT name FROM cscart_seo_names WHERE object_id = 228 AND type = 'c' AND dispatch = '' AND lang_code = 'EN'
0.00018 - SELECT name FROM cscart_seo_names WHERE object_id = 229 AND type = 'c'
0.00015 - SELECT name FROM cscart_seo_names WHERE object_id = 229 AND type = 'c' AND dispatch = '' AND lang_code = 'EN'
0.00019 - SELECT name FROM cscart_seo_names WHERE object_id = 230 AND type = 'c'
0.00016 - SELECT name FROM cscart_seo_names WHERE object_id = 230 AND type = 'c' AND dispatch = '' AND lang_code = 'EN'
0.00018 - SELECT name FROM cscart_seo_names WHERE object_id = 216 AND type = 'c'
0.00015 - SELECT name FROM cscart_seo_names WHERE object_id = 216 AND type = 'c' AND dispatch = '' AND lang_code = 'EN'
0.00018 - SELECT name FROM cscart_seo_names WHERE object_id = 170 AND type = 'c'
0.00014 - SELECT name FROM cscart_seo_names WHERE object_id = 170 AND type = 'c' AND dispatch = '' AND lang_code = 'EN'
0.00018 - SELECT name FROM cscart_seo_names WHERE object_id = 217 AND type = 'c'
0.00015 - SELECT name FROM cscart_seo_names WHERE object_id = 217 AND type = 'c' AND dispatch = '' AND lang_code = 'EN'
0.00017 - SELECT name FROM cscart_seo_names WHERE object_id = 215 AND type = 'c'
0.00015 - SELECT name FROM cscart_seo_names WHERE object_id = 215 AND type = 'c' AND dispatch = '' AND lang_code = 'EN'

0.00017 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's'
0.00013 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'checkout.cart' AND lang_code = 'EN'
0.00022 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'checkout.cart'
0.00015 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's'
0.00013 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'checkout.cart' AND lang_code = 'EN'
0.00022 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'checkout.cart'

0.00018 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's'
0.00014 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'promotions.list' AND lang_code = 'EN'
0.00023 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'promotions.list'
0.00016 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's'
0.00013 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'sitemap.view' AND lang_code = 'EN'
0.00023 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'sitemap.view'
0.00036 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's'
0.00015 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'categories.catalog' AND lang_code = 'EN'
0.00024 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'categories.catalog'
0.00016 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's'
0.00013 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'profiles.update' AND lang_code = 'EN'
0.00024 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'profiles.update'
0.00016 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's'
0.00014 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'checkout.cart' AND lang_code = 'EN'
0.00023 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'checkout.cart'
0.00023 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's'
0.00014 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'auth.recover_password' AND lang_code = 'EN'
0.00024 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'auth.recover_password'

0.00039 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's'
0.00014 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'profiles.update' AND lang_code = 'EN'
0.00024 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'profiles.update'
0.00016 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's'
0.00015 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'profiles.downloads' AND lang_code = 'EN'
0.00024 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'profiles.downloads'
0.00016 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's'
0.00014 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'auth.login_form' AND lang_code = 'EN'
0.00023 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'auth.login_form'
0.00016 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's'
0.00014 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'profiles.add' AND lang_code = 'EN'
0.00024 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'profiles.add'
0.00016 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's'
0.00014 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'orders.search' AND lang_code = 'EN'
0.00023 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'orders.search'
0.00016 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's'
0.00014 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'auth.logout' AND lang_code = 'EN'
0.00023 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'auth.logout'
0.00023 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's'
0.00014 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'tags.summary' AND lang_code = 'EN'
0.00024 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'tags.summary'
0.00016 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's'
0.00014 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'rma.returns' AND lang_code = 'EN'
0.00023 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'rma.returns'
0.00017 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's'
0.00014 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'reward_points.userlog' AND lang_code = 'EN'
0.00024 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'reward_points.userlog'
0.00018 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's'
0.00014 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'auth.recover_password' AND lang_code = 'EN'
0.00023 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'auth.recover_password'
0.00017 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's'
0.00013 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'gift_certificates.add' AND lang_code = 'EN'
0.00022 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'gift_certificates.add'
0.00016 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's'
0.00013 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'sitemap.view' AND lang_code = 'EN'
0.00025 - SELECT name FROM cscart_seo_names WHERE object_id = 0 AND type = 's' AND dispatch = 'sitemap.view'

3

My cart is running good by converting it to html catalog but if I change it back to dynamic then it opens to many processes and crashes my dedicated box.



Am going to give this to cs acrt to look at, but why does a html cart not crash the server?

4

[quote name=‘badmaash’]My cart is running good by converting it to html catalog but if I change it back to dynamic then it opens to many processes and crashes my dedicated box.



Am going to give this to cs acrt to look at, but why does a html cart not crash the server?[/QUOTE]



Because by creating a HTML catalog, cs-cart wouldn’t need to query the database some many times during a page load. It’s a static HTML file.