I installed v2.0.11 few weeks ago [clean install] and imported a supplier price list. Since then visiting the site takes 8-10 seconds to load. The load time varies! Even in admin mode, clicking on links take ~8 secs to loadl I have even tried SmartOptimiser no difference… actually added 1-2 secs longer. I have turned it off right now.
Test mode: tba
I turned off DNS as I thought the external DNS servers were causing the delay.
VPS server spec:
VMware Based VPS
512MB Memory
25GB Hard Disk Space
1Gbps Uplink
1 IP Address
2 Shared CPU Cores
CS-Cart info:
Category inventory:
Total: 2987
Active: 2987
Hidden: 0
Disabled: 0
Product inventory:
Total: 36600
Configurable: 0
In stock: 0
Active: 36600
Disabled: 0
Downloadable: 0
Out of stock: 0
Hidden: 0
Free shipping: 0
There are 0 images currently… It’s already slow as it is!
Turned off all addon’s except for Form Builder, My Changes, SEO and Suppliers. Even turned off AJAX.
On the server side I only have httpd, mysqld, vsftpd and sendmail running.
I tried various PHP, mysql config tweaks. Same result. I turned off a lot of modules in httpd.conf
There’s only one site on the server, the cs-cart one. I have tried cherokee web server and it’s the same. Cherokee is actually worst some times the pages 404 on me. Lighttpd not going to bother…
I installed other scripts like phpmyadmin/phpBB3 and they run fast [they are off atm]. But when CS-cart gets into the mix hell break loose!
[quote name=‘hbtrading’]it might be your host, who do you host with ?
As your cart is now there is no reason it should be so slow unless one of the sites on your server has heavy traffic.
I have my cs-cart hosted on a shared server and it loads almost instantly most of the time.[/QUOTE]
The statistics in the administration/addons? It’s already disabled
Looks like the VPS is dead. Takes only ~3 visits and it’s already on it’s knees.
I can’t ssh in… going to remove the address in the original post.
Update: I contacted the VPS provider. They saw the top results and said I have huge I/O… they’re moving me to another SAN. Going to take 60 mins… see how it goes
So question is. Officially how many categories or products does CS-Cart support before the server struggles? Note that I tried the above on a Intel Quad Core 9650 with 8GB ram with RAID0 volumes, separate from the VPS and it’s still slow. ~8-10 secs to load anything.
It will be great if you can pass a sample set of your product/categories data to cscart team and ask them to import into a fresh copy on their developing server and run the site.
Then they will know exactly where the bottleneck is in causing the slow loading (the complicated multiple joins sql queries?).
I doubt they have a decent set of sample data near your size to test with at all.
But it’s just my assumption.
And it will be hugely beneficial for them to actually test on a set of large sample data. Then the currently available demo data.
There is two csv files inside. It’s better if you upload them both to the server and run the import direct from server option. Category delimited by @@@
It will be interesting to see how it goes on your machines.
There is two csv files inside. It’s better if you upload them both to the server and run the import direct from server option. Category delimited by @@@
It will be interesting to see how it goes on your machines.[/QUOTE]
Ahh ok and what you have take for the prducts csv and then? Also i have take tab as delemiter but it isnt ending to import… but there categorys my localhost installed are very fast.
It should end unless your php max execution settings is set low?
Each one should take ~8 minutes depending on the system environment.
The csv contains both categories and products. CS-Cart will automatically create the categories & products.
Make sure you decompress them in the server.
tar zxvf export.tar.gz it will output two files
If you want to do it in Windows, use winrar @ [url]www.rarlabs.com[/url] to extract the tar.gz files
[quote name='Triplex']Ahh ok and what you have take for the prducts csv and then? Also i have take tab as delemiter but it isnt ending to import.... but there categorys my localhost installed are very fast.[/QUOTE]
To test whether it’s the server or not. I have installed a trial version of X-cart. It run’s fine! Took 3-4 hours to import the categories and products in one hit though.
Takes 1-2 secs to load. But I don’t see dynamic category menuing though.
While I understand they’re two different things… I’m out of ideas and need a working solution for my client. I have submitted a ticket to CS tech see how it goes.
[quote name=‘onture’]Average 5 seconds on both sites. Can you list me the specs of the server? is it shared for VPS?
mysqld my.cnf?
httpd.conf?
php.ini?
Thanks[/QUOTE]
Sorry. I know nothing about your questions about those three configuration files. They are shared. One with single Xeon (4cpus), 8GB Ram. One with Dual Xeon (16cpus), 12GB or 24GB ( forgot). From my end, I got around 4 seconds on the lower specs server and 3.25 seconds from higher specs server. By the way, I’m in Montreal, Quebec.
Mines between 5 to 9 secs as well… usually the first time you load the website that part takes the longest ~10 secs. Even clearing the cache it would still take 5 secs.
[quote name=‘freebull’]I have to update the responding time.
I tried to access to my demo site on other several different computers. The loads were between 4 seconds and 9 seconds.
I have another issue with CS-Cart. I’ll open another post special for it.[/QUOTE]
