cyberwala Posted August 17, 2013 Share Posted August 17, 2013 hello, My shopping carts are very slow, performance is not good. kindly suggest speedup my websites: Now products are only 3000; I wanted to upload 50000 products; kindly suggest what best hardware & bandwidth to be maintained. www.riocart.com www.cyberwala.com www.kcomputers.com Link to comment Share on other sites More sharing options...
vekia Posted August 17, 2013 Share Posted August 17, 2013 what is the size of your ps_cart table? 1 Link to comment Share on other sites More sharing options...
cyberwala Posted August 17, 2013 Author Share Posted August 17, 2013 I d't know.. how to check .. plz suggest.. Link to comment Share on other sites More sharing options...
vekia Posted August 17, 2013 Share Posted August 17, 2013 connect to your database via database manager like phpmyadmin then open table ps_cart how many rows you've got there? 1 Link to comment Share on other sites More sharing options...
cyberwala Posted August 17, 2013 Author Share Posted August 17, 2013 250 tables Sum 11,047 InnoDB utf8_unicode_ci 8.4 MiB 0 B riocart.com 250 tables Sum ~64,718 InnoDB utf8_unicode_ci 13.1 MiB 0 B Sum ~1,494,632 InnoDB utf8_unicode_ci 169 MiB 245 B Link to comment Share on other sites More sharing options...
cyberwala Posted August 17, 2013 Author Share Posted August 17, 2013 Sum ~1,494,632 InnoDB utf8_unicode_ci 169 MiB 245 B 250 tables Sum ~1,494,632 InnoDB utf8_unicode_ci 169 MiB 245 B Link to comment Share on other sites More sharing options...
vekia Posted August 17, 2013 Share Posted August 17, 2013 you're talking about whole database stats probably, you need to check only one table ps_cart 1 Link to comment Share on other sites More sharing options...
cyberwala Posted August 17, 2013 Author Share Posted August 17, 2013 Showing rows 0 - 29 ( ~470 total , Query took 0.0010 sec) i am not able share the pic. give your email will forward Link to comment Share on other sites More sharing options...
Recommended Posts