Checkout page is so slowly!

hi all,



I have met a problem,its so serious.<br /> All of my website is ok,but when somebody come accross one page checkout,then choose the paymen method,no matter paypal or moneybookers,the page will hung up for 1-2 minutes,and kept saying loading and not advance the screen.<br /> I dont know what happen and how to solve this problem.can somebody help.



I found when i save all of the pages,such as add product,the process also very slow.



There are some inforamtion below:



Host: hostmonster,

SSL: Comodo CA Limited



Many thanks!



Joe

I get the same problem :frowning:

[quote name=‘thanhh83’]I get the same problem :([/QUOTE]



I have checked your website,the same problem!



Which host do you use?

[quote name=‘zoujun2046’]I have checked your website,the same problem!



Which host do you use?[/QUOTE]



One dedicated server from:



[url]http://www.liquidweb.com/[/url]

I have a few reports of the same issue.



Stuck on payment method using one page checkout.

anyone please help

[quote name=‘zoujun2046’]hi all,



I have met a problem,its so serious.
All of my website is ok,but when somebody come accross one page checkout,then choose the paymen method,no matter paypal or moneybookers,the page will hung up for 1-2 minutes,and kept saying loading and not advance the screen.
I don
t know what happen and how to solve this problem.can somebody help.



I found when i save all of the pages,such as add product,the process also very slow.



There are some inforamtion below:



Host: hostmonster,

SSL: Comodo CA Limited



Many thanks!



Joe[/QUOTE]

I get the same problem

We have the same problem on a number of cs-cart installations, when a user gets to the checkout page, fills in their information and then chooses a payment method (ie PayPal), once they click on the button to continue (which then brings up a loading page whilst it connects to PayPal or another service provider) it seems to take a good 30 seconds to a minute before finally loading the payment providers payment page.



Any help on this one cs-cart? It would be appreciated.

What cs cart build is this happening on?

version: 2.0.12 and 2.0.11 so far.

[quote name=‘Cyberzia’]We have the same problem on a number of cs-cart installations, when a user gets to the checkout page, fills in their information and then chooses a payment method (ie PayPal), once they click on the button to continue (which then brings up a loading page whilst it connects to PayPal or another service provider) it seems to take a good 30 seconds to a minute before finally loading the payment providers payment page.



Any help on this one cs-cart? It would be appreciated.[/QUOTE]



something like this :(. Try do delete cache but the same

Here is just a very very small sample of what the site was doing when it was taking a long time to load:



stat(“/home1/yoosmart/public_html/var/cache//pfilters_52b281fbe0fad68e4a0eb118552cb7ce.GET_categories_view.0_1.EN.USD.php”, {st_mode=S_IFREG|0666, st_size=4339, …}) = 0

stat(“/home1/yoosmart/public_html/var/cache//pfilters_7a96a8a7186470f9897e598e6ec6322b.GET_products_search.0_1.EN.USD.php”, {st_mode=S_IFREG|0666, st_size=865, …}) = 0

stat(“/home1/yoosmart/public_html/var/cache//pfilters_3c52c1ba693976d7a307669d53c03b00.GET_product_features_view.0_1.EN.USD.php”, {st_mode=S_IFREG|0666, st_size=3223, …}) = 0

stat(“/home1/yoosmart/public_html/var/cache//pfilters_1b0902ef88682da29f05c72968310697.GET_products_search.0_1.EN.USD.php”, {st_mode=S_IFREG|0666, st_size=1588, …}) = 0

stat(“/home1/yoosmart/public_html/var/cache//pfilters_d349e5bf5f09b38d8d28dd3119deab17.GET_products_search.0_1.EN.USD.php”, {st_mode=S_IFREG|0666, st_size=757, …}) = 0

stat(“/home1/yoosmart/public_html/var/cache//pfilters_ed573537ec4fc2aae3a154496391bb69.GET_product_features_view.0_1.EN.USD.php”, {st_mode=S_IFREG|0666, st_size=875, …}) = 0

stat(“/home1/yoosmart/public_html/var/cache//pfilters_f85c4a58035165642295e9d1f58421e8.GET_categories_view.0_1.EN.USD.php”, {st_mode=S_IFREG|0666, st_size=875, …}) = 0

stat(“/home1/yoosmart/public_html/var/cache//pfilters_e6bf6e4c5433fcebca097697fbd26a51.GET_product_features_view.0_1.EN.USD.php”, {st_mode=S_IFREG|0666, st_size=131, …}) = 0

stat(“/home1/yoosmart/public_html/var/cache//pfilters_5bfac49bb9ea73c70864a129a393d8d0.GET_product_features_view.0_1.EN.USD.php”, {st_mode=S_IFREG|0666, st_size=3223, …}) = 0

stat(“/home1/yoosmart/public_html/var/cache//pfilters_e2f2332a37679a0cd5cb087dd6623f88.GET_product_features_view.0_1.EN.USD.php”, {st_mode=S_IFREG|0666, st_size=865, …}) = 0

stat(“/home1/yoosmart/public_html/var/cache//pfilters_3d6121bca7b4ef79cc0e23b1986803fc.GET_categories_view.0_1.EN.USD.php”, {st_mode=S_IFREG|0666, st_size=4118, …}) = 0

stat(“/home1/yoosmart/public_html/var/cache//pfilters_48639bcce661b34aec2df1facccb7d70.GET_categories_view.0_1.EN.USD.php”, {st_mode=S_IFREG|0666, st_size=644, …}) = 0

stat(“/home1/yoosmart/public_html/var/cache//pfilters_312ad5b5c60bc871244ebfcd900047a4.GET_categories_view.0_1.EN.USD.php”, {st_mode=S_IFREG|0666, st_size=642, …}) = 0

stat(“/home1/yoosmart/public_html/var/cache//pfilters_2461ad95fd99ac401b9912ff471330d1.GET_categories_view.0_1.EN.USD.php”, {st_mode=S_IFREG|0666, st_size=639, …}) = 0

stat(“/home1/yoosmart/public_html/var/cache//pfilters_cea7649c7a7edc8ec5db29b500154b94.GET_product_features_view.0_1.EN.USD.php”, {st_mode=S_IFREG|0666, st_size=4232, …}) = 0

stat(“/home1/yoosmart/public_html/var/cache//pfilters_e26b6ce8c37a5fcdfe881de9a2ef0e5a.GET_categories_view.0_1.EN.USD.php”, {st_mode=S_IFREG|0666, st_size=645, …}) = 0





You had almost 9000 files in that cache directory and the process was running through every single one of them. This is an issue with the software. The issue can be resolved by removing the public_html/var/cache/ directory or there should be an option in the admin area to clear the cache.

[quote name=‘zoujun2046’]You had almost 9000 files in that cache directory and the process was running through every single one of them. This is an issue with the software. The issue can be resolved by removing the public_html/var/cache/ directory or there should be an option in the admin area to clear the cache.[/QUOTE]

You can clear the cache by logging into the admin area and then going to [url]http://YOURDOMAIN/admin.php?cc[/url].



If you have renamed your admin.php, substitute your filename for admin.php. You can add this to your Quick menu in the admin for easier future access.



Bob

[quote name=‘jobosales’]You can clear the cache by logging into the admin area and then going to [url]http://YOURDOMAIN/admin.php?cc[/url].



If you have renamed your admin.php, substitute your filename for admin.php. You can add this to your Quick menu in the admin for easier future access.



Bob[/QUOTE]



Thanks Bob.



Its Ok now under clear the cache.

I need to clear the cache when i use the admin panel. If the cache can
t be cleared one or two days,the problem appears. So i guess can i use the cron job to clear cahce if possible and how to do this.



Joe

Got the same problem here. Seems it tries to init a 7000+ lines array and that takes a while :wink:



created a cronjob in my directadmin tab:

0 9-22/2 * * * wget -O /dev/null -q [url]yourdomain.com >/dev/null 2>&1



This clears te tab every 2 hours from 9:00 until 22:00. Seems you dont need to be logged in to clear the cache!

[quote name=‘flimflap’]Got the same problem here. Seems it tries to init a 7000+ lines array and that takes a while :wink:



created a cronjob in my directadmin tab:

0 9-22/2 * * * wget -O /dev/null -q [url]yourdomain.com >/dev/null 2>&1



This clears te tab every 2 hours from 9:00 until 22:00. Seems you dont need to be logged in to clear the cache![/QUOTE]



Thanks flimflap.



Regarding to the command, i just need copy the command below to my cron job and change the domain address,any other changes?

09-22/2 *** wget -O /dev/null -q [url]yourdomain.com >/dev/null 2>&1



Joe

not really, unless you have changed your admin.php filename or if you want the cron to go off at other times.

09-22/2 *** wget -O /dev/null -q [url]yourdomain.com >/dev/null 2>&1



So the “***” doesn`t need to change



I see ,



Thanks for your help

In my case is problem in number of generated pfilters* files in var/cache directory, it grows very fast and practically endless, number of categories and filter combinations is simple too high. Although I have ext3 with indexed b-tree dirs it reaches the limits of filesystem quickly and slowdowns the script execution.



Caching should be definitely improved here. Maybe it’d be better to generate MD5 hashes of these dynamic filters and store the PHP arrays in indexed MySQL table.



I turned off “Show products from subcategories of the selected category” option and lets see what happens.



And about wget command,



wget -q --spider [url]Eigen Webwinkel beginnen? Webshop beginnen? Gratis uitproberen | myShop.com



is just simpler. :wink:

Hello,



Just rewrote the cache storage using sqlite database to check the differences with file storage. Please try on your carts.



Just extract the file from zip archive and copy it to “core” directory, then clean up the “var/cache” directory.

sqlite_caching.zip