Query Cache v1.0

[luxurywatches]

Query Cache v1.6 can't install

1017 Can't find file: './hostname/zen_get_terms_to_filter.frm' (errno: 13)
in:
[select * from zen_get_terms_to_filter]

[data_digger]

Query Cache v1.6 can't install

1017 Can't find file: './hostname/zen_get_terms_to_filter.frm' (errno: 13)
in:
[select * from zen_get_terms_to_filter]

It has nothing to do with Query Cache. Most probably someone (You, Your hosting company, some of Your scripts or hacker) changed permission to ./hostname/zen_get_terms_to_filter.frm and possibly other files. Check that MySQL has privilages to access the file (read/write).

[wipasnapa_dev]

Hi,

Im running zencart 1.3.8 .

Here are the parse times,

On localhost :

Before installing this Add-on
Parse Time: 0.721 - Number of Queries: 1574 - Query Time: 0.330065291428

After Installing the Add-on
Parse Time: 0.511 - Number of Queries: 370 - Query Time: 0.228095473282

On centralized Test machine ( higher load/more users/larger db)

Before installing this Add-on
Parse Time: 1.781 - Number of Queries: 1443 - Query Time: 1.17740702115

After Installing the Add-on
Parse Time: 2.140 - Number of Queries: 1426 - Query Time: 1.54411397633
Parse Time: 1.766 - Number of Queries: 1426 - Query Time: 1.21343658868


As you can see, localhost shows the drastic improvement but the centralized testing server shows negligible improvements.

I tried setting all combinations of QC_USE_PRODUCT_QUERY_DETECTION and
QC_ZEN_GET_CATEGORIES_PRODUCTS_LIST_PREFETCH but to no avail.

Any idea what could be going wrong ?

Any help appreciated !

[data_digger]

It seems that You haven't uploaded all files. Compare Your online store with files from distribution. Most probably You haven't uploaded

includes/classes/db/mysql/query_factory.php
includes/classes/query_cache.php 

[gsdcypher]

installing this module seems to have broken the encrypted master password module. any ideas on how to fix so they are compatible?

thanks

[gsdcypher]

follow up. now seems entirely coincidental and unrelated.
pti.

[JimmyV]

Took my queries from over 5000 down to under 1000 so pretty dramatic loadtime difference.

THANKS VERY MUCH excellent work