Then for Zen Cart >= 1.5.0 it might be worth to have MySQL query_cache enabled.
Type: Posts; User: data_digger
Then for Zen Cart >= 1.5.0 it might be worth to have MySQL query_cache enabled.
Turn off query cache on MySQL server (it has scalability problems and it's pruned too often to be useful - unless new version of Zen Cart does not update products_view counter in products table)....
My first shot would be to use value of attribute to create css class (like 'attribute_name_value') and define that class to show part of sprite. It ain't easy but can be done.
Your server generates the page in around 1.5 seconds which is waaaaay too much for an e-commerce site. I would consider anything above 0.5 seconds as slow. Both Your database server and web server...
I forgot to mention, that chances are that You're allowed only allowed to view Your schemas portion of the INFORMATION_SCHEMA database and You don't have to put even 'name_of_your_database'. Just...
Managing numerous Zen Cart instances is MAJOR pain in the uhm.... it's a headache. Consider for example updating Zen Cart version, but take into account that each of Your Zen Cart installations will...
Here's method to find out which tables actually take most space. Execute the query in phpmyadmin, it'll return list of tables sorted by their size in descending order:
SELECT ( (t.DATA_LENGTH +...
===============
I wrote the post first in 'The Zen Pub' section, but I haven't realized that very few people goes there. I hope that this little off topic won't anger You nor admins, and Your...
Hello,
Does anyone know of free (or paid) module that allows customers to create an account and log in using Facebook Authentication? Do You have any experience with it? Is it worth to install it?...
Hello,
I'm not sure which versions exactly are affected but I know that the bug exists at least since 1.3.8a till 1.5.0.
When search keywords contain single '0' character (for example "oven 0')...
I can’t reproduce that behavior on clean Zen-Cart v1.3.9h. Which version of ZC do You have? Have You installed and other addons?
You can view QC1.7 beta on zc 1.3.9h here:
Zen Cart v1.3.9h with...
Hello,
I've created module that spreads images over given number of subdomains on store. It greatly speeds up page loading times, gives better performance score in Google Page Speed and Yahoo...
Can You check if query time is also high? What times do You get? PM me as it's most probably not related to QueryCache and We shouldn't continue the discussion here.
I highly recommend changing storage engine of whos_online table to InnoDB. You'll avoid locking issues with this table (it's updated on EVERY request).
It doesn't matter.
Install the version for 1.3.9h
QueryCache v1.7 for Zn Cart 1.3.9h has been released. Currently the mod is in 'beta' stage, but it should be stable.
Download QueryCache v1.7-beta-zc-1.3.9h
Please report any bugs here or on...
fawad123:
Install Query Cache
Install Query Log
Check how Query Log works
Check which queries take most time to execute (they'll be in red) and post them here
With that I will be able to...
As far as I know the module does not reduce parse times and query times on its own. You have to decide which parts of Your store are to be cached and do it manually (again, as far as I know).
As...
I see a lot of errors in this snippet of code. I'm not sure if it's vBulletin forum text formatting though... Can You send me this file/code on data-diggers at data-diggers.com?
Then why You want to get IDs of products and not list of attributes?
What are You trying to achieve? If You want to get list of products regardless of how many options they have why to query against attributes table in the first place?
Posted via Mobile Device
Try to run it via phpmyadmin. If there'll be error paste it here. I've tested the command on vanilla zen cart 1.3.8 @ MySQL 5.1. It should work.
UPDATE products
SET products_image = CONCAT(LEFT(products_image,LENGTH(products_image)-3),'jpg')
WHERE products_image LIKE '%.gif'
Yes, there should be NO '.' in front of 'jpg'
Cache built in MySQL does not (in general) improve performance of Zen Cart. It might seem it does, but it doesn't. It improves performance of stores with very very low traffic only (when there's only...
There's support thread:
User Tracking Interface [UTI] Support Thread
Hello
This is official support thread for the User Tracking Interface module.
If You use version 1.0 please update to newest version. There's serious bug in version 1.0. You can download it...
If You don't want to use litmusapp or something like that check Your emails only under few most popular mail agents. Checking HTML newsletter under 10 mail agents by hand is overkill.
Use WYSISWYG...
I'm pretty much sure that You shouldn't use just any HTML editor to make HTML email. HTML support in mail clients is very variable. Some clients support styles, some don't, some only accept styles...
By the way, shopping cart page needs serious rewriting. It seems that the more distinct products customer adds to shopping cart the more time it takes to load the page. As far as I observed time to...
Yep, as stated in read me file (You've read it, right? :P ) You should check if this switch speeds up or slows down Your site.
Thanks for feedback.
There's mod that does A/B testing for Zen Cart. You can find it on my website here: Randomized Tests For Zen Cart. Google Web Site Optimizer has probably more features, but there are some tests that...
I promised to release new, more memory efficient version of Query Cache soon – unfortunately (or fortunately) it seems that PHP is quite good at managing memory and there’s not much to improve....
Well, no. Getting results from EZ pages would not be hard. But advanced search displays list of products. Do You want to display EZ page results together with products in product listing table? Or as...
How would You like to present results from such search?
Posted via Mobile Device
Maybe zen_db_cache table got too big? Clear it of all contents by executing MySQL command:
TRUNCATE TABLE zen_db_cache
If You don't know how to do it here's my screencast:...
Your solution does not work?
yellow, shouldn't this line:
if(SIMPLE_CACHE_STATUS == 'false' || ($post_safe && $_SERVER["REQUEST_METHOD"] == 'POST'))
be:
if(SIMPLE_CACHE_STATUS == 'false' || (!$post_safe &&...
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...
SELECT DISTINCT c.*
FROM customers c, orders o, orders_products op
WHERE c.customers_id = o.customers_id
AND o.orders_id = op.orders_id
AND op.products_id = YOUR_PRODUCT_ID
Strange ... Those queries look up by primary key - it should be very fast. Can You paste here also output of:
SHOW INDEX FROM zen_seo_cache
I'm most interested in 'Cardinality'.
Also write how...
I don't think You can solve this with Query Cache 1.6 (but it is still good idea to have it installed ;). The query execution time looks suspicious. It looks like there's no index on cache_id field....
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...
Clean Zen Cart (without addons) also has performance problems on orders.php page (I'm not sure about customers.php page) when orders/orders_products table gets big (10k+ entries). Only solution I'm...
Here's link to latest version of Query Cache:
data-diggers.com/contribs/query-cache/downloads/querycache-current.zip
Installation instructions are in INSTALL.TXT file in .zip file. There's also...
Thanks, I haven't realized that this was part of standard.
I always wondered what that was for but never had time to search/ask. I thought that those are oscommerce/zen cart specific variables.
What is that for?
Hosting company should be able to tell You if Your traffic isn't normal.
Is this new site or old one? How many products You have? Have You added many products/categories/manufacturers/images...
Try to install Query Cache (in my footer) - it might bring it down to ~1000 queries and sensible query times.
What does parameters named 'x' and 'y' do in advanced_search_results request? I can't figure it out.. It seems that they aren't used anywhere (at least not via $_GET['x']). So what they do?