Nipsy Posted February 5, 2004 Share Posted February 5, 2004 I have been helping a user through an order, comprised of 100 different items, in quantities from 1 - 30, but averaging around 12. After I have about 50 items in the cart, it slows to a crawl (3-4 minute load times). Is there a way to speed this up? Link to comment Share on other sites More sharing options...
Guest Posted February 5, 2004 Share Posted February 5, 2004 what kind of server is the store on, what speed of communication lines, what is the operating system, lots of variables here . . . Link to comment Share on other sites More sharing options...
Nipsy Posted February 5, 2004 Author Share Posted February 5, 2004 The server is a shared FreeBSD Dual Xeon box, which is shared with 11 other relatively static sites, sitting at a large, but not major, hosting provider. The lines to me (I've tried home and work) are 3mbit cable, and 1.5mbit DSL. No other items have slowed down on the site, just this super full cart. For instance, I can use Safari to start loading and allprods page with images, run some sim spiders, use IE to begin a db backup, and still browse at normal speeds as most users. However, if I am doing nothing else, the user with the very full cart still moves at a snail's pace. Server info: Server OS: FreeBSD 4.5-RELEASE Database: MySQL 3.23.49-log Server Date: 02/05/2004 11:30:44 Datebase Date: 02/05/2004 11:30:44 Server Up Time: 11:30AM up 14 days, 10:31, 1 user, load averages: 1.81, 1.35, 1.34 HTTP Server: Apache/1.3.27 (Unix) AuthMySQL/2.20 mod_perl/1.26 PHP/4.3.1 mod_ssl/2.8.12 OpenSSL/0.9.6h PHP Version: 4.3.1 (Zend: 1.3.0) Link to comment Share on other sites More sharing options...
Guest Posted February 5, 2004 Share Posted February 5, 2004 your load average is actually kind of high, i have about 30 databases on mine, here is what i get from the 'top' command: load averages: 0.38, 0.30, 0.22, up 387+ .... and the time, have over 60 processing so perhaps you need to reevaluate your host and how they have the server set[up. my cpu states go from 2% to 60% but in seconds, while something is being accessed, then it drops. system averages 5%, 0.5 interrupt, 91.5% idle time, i have memory set low Link to comment Share on other sites More sharing options...
Nipsy Posted February 5, 2004 Author Share Posted February 5, 2004 Is there anything I should look at in session handling, cookie use, gzip compression or persistent connections that would reduce load or improve speed? Link to comment Share on other sites More sharing options...
Guest Posted February 5, 2004 Share Posted February 5, 2004 not really, more of an apache issue i believe Link to comment Share on other sites More sharing options...
user99999999 Posted February 5, 2004 Share Posted February 5, 2004 I think it would be a SQL issue. Turn on parse time logging and SQL logging and see what the results are. Are you using MS2? Do you have any special shipping mods. Link to comment Share on other sites More sharing options...
1quicksi Posted February 5, 2004 Share Posted February 5, 2004 You can try changing/adding my.cnf to below and restart mysql Remember to back up first!!! [mysqld] max_connections = 500 key_buffer = 16M myisam_sort_buffer_size = 64M join_buffer_size = 1M read_buffer_size = 1M sort_buffer_size = 2M table_cache = 1024 thread_cache_size = 64 wait_timeout = 1800 connect_timeout = 10 max_allowed_packet = 16M max_connect_errors = 10 query_cache_limit = 1M query_cache_size = 32M query_cache_type = 1 skip-innodb [mysqld_safe] open_files_limit = 8192 [mysqldump] quick max_allowed_packet = 16M [myisamchk] key_buffer = 64M sort_buffer = 64M read_buffer = 16M write_buffer = 16M knowledge base | Contributions | Search Link to comment Share on other sites More sharing options...
Nipsy Posted February 5, 2004 Author Share Posted February 5, 2004 I am using MS2, with some extensive mods. Seperate pricing is causing more queries, but that should not affect the speed of the system as more items enter the cart. The shipping mods shouldn't come into play until doing the calculations, right? I have noticed things get worse in proportion to the number of items. I'll have the server manager look at this thread, and also try the parse timer... Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.