DELETE_ME Posted March 11, 2004 Share Posted March 11, 2004 I have been playing with the oscommerce package for 2 weeks now. And I find that this product is a great alternative, and one I would very much like to use for a project I have going on, I find that the biggest killer of this application is the ammount of queries to the database. I have approxamitly 3000 products in it right now with 1000 or so catagories, all of my data is structured properly. And yet It just takes forever to load. And forget using the administrative plugins for the catagories, and custemers. It times out every time. Its as if its reading everything for a few peices of data. I have reindexed every table, and optimized them as well. I have segregated teh SQL portion of the application to another server Compaq ML370g3 2.5gbs ram. The web server is also running this slow. Is there any suggestions or tips that I am not aware of before I give oscommerce up? I really hope so I enjoy the use of open source software, and I think this product has a ton of potential. Please let me know. Please check out the web site that we are developing to give you and idea of how slow its working, www.cabvi.org/catalog Earl IT manager Link to comment Share on other sites More sharing options...
DELETE_ME Posted March 11, 2004 Author Share Posted March 11, 2004 Correction 30,000 products and adding 10,000 more today Link to comment Share on other sites More sharing options...
mark27uk3 Posted March 11, 2004 Share Posted March 11, 2004 Hi Earl, Try this contribution Faster Page Loads, Less DB Queries I have not used it but from what I have read on this forum it works really well. Mark Lifes a bitch, then you marry one, then you die! Link to comment Share on other sites More sharing options...
DELETE_ME Posted March 11, 2004 Author Share Posted March 11, 2004 I think its more the administration that I am concerned with , I should re iterate, the page is loading pretty quickly . Its the administration that times out every time. Link to comment Share on other sites More sharing options...
Guest Posted March 11, 2004 Share Posted March 11, 2004 enable and load gzip compression, for the system timing out, could be many things, so i would look at the server access and error logs, (not a part of oscommerce) and if that is still a problem, then enable sql logging and see what is going on there. this is what i saw for the catalog/index.php page Connection Rate Download Time 14.4K 62.19 seconds 28.8K 33.29 seconds 33.6K 29.17 seconds 56K 19.26 seconds ISDN 128K 8.95 seconds T1 1.44Mbps 4.80 seconds Link to comment Share on other sites More sharing options...
DELETE_ME Posted March 11, 2004 Author Share Posted March 11, 2004 Sadly that does not work. Link to comment Share on other sites More sharing options...
wizardsandwars Posted March 11, 2004 Share Posted March 11, 2004 I think you have some sort of problem with your categories.php. This page hsould not load any slower than you index.php. Did you make *any* changes to it? ------------------------------------------------------------------------------------------------------------------------- NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit. If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help. Link to comment Share on other sites More sharing options...
Guest Posted March 11, 2004 Share Posted March 11, 2004 can i ask are you using easy populate to add some many products?! Link to comment Share on other sites More sharing options...
DELETE_ME Posted March 12, 2004 Author Share Posted March 12, 2004 I am using easy populate to add these products, and the catagories page in the admin section has not been modified at all. Link to comment Share on other sites More sharing options...
wizardsandwars Posted March 12, 2004 Share Posted March 12, 2004 Well, there definalty seems to be a problem proprietary to your site. I've seen other OSCommerce sites with 100's of 1000's of products that load the categories.php faster than yours. ------------------------------------------------------------------------------------------------------------------------- NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit. If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help. Link to comment Share on other sites More sharing options...
DELETE_ME Posted March 12, 2004 Author Share Posted March 12, 2004 Are you talking in the admin section? I would like to see an example of such a site, please restore my faith in this product. Link to comment Share on other sites More sharing options...
DELETE_ME Posted March 13, 2004 Author Share Posted March 13, 2004 I seemed to have fixed my problem. I created additional indexes in the MYSQL database and that improved the speed of the admin interface and the pages by 3/4ths wich is quite a bit when you are talking 120 seconds to do a query. Also my CPU utilization on the web server has dropped by 90% wich means I can handle alot more visits. Thank you all for you're help. I hope this information helps some people. Link to comment Share on other sites More sharing options...
Guest Posted March 13, 2004 Share Posted March 13, 2004 here is the time now: Connection Rate Download Time 14.4K 40.83 seconds 28.8K 22.72 seconds 33.6K 20.13 seconds 56K 13.92 seconds ISDN 128K 7.45 seconds T1 1.44Mbps 4.85 seconds Link to comment Share on other sites More sharing options...
OceanRanch Posted March 13, 2004 Share Posted March 13, 2004 Two things, 1. I see that configuration->Cache->Use Cache is set to false. I believe setting this true might improve the category loading time. However it may not help out in the admin section. 2. You might want to also set sessions to 'mysql' in both your catalog and admin configure.php's. 3. A Linux apache server might be faster (no php cgi) than your Windows NT IIS server, but I don't want go down that path of discussion. ;) The site seems to run very nicely today, although I am on a cable modem. Good Luck HTH Tom Link to comment Share on other sites More sharing options...
ptrau Posted March 13, 2004 Share Posted March 13, 2004 first...I just accessed you catalog page and it was wicked fast second....I just pm'd you on an URGENT topic "Aliiiiive, it's alive, it's ALIIIIIIIIIIIIIVE!!!" Link to comment Share on other sites More sharing options...
DELETE_ME Posted March 25, 2004 Author Share Posted March 25, 2004 To speed up you're catalog in oscommerce the best way is to do the following. Use PHPMYADMIN Open the oscommerce database, and choose the following tables Anything catagories Anything products Create seperate indexes for each feild in the table, that fixed my speed of my site much better. I am sorry I cant explain it better , but I hope it helps some people out. To see the speed of a site that has this done go to www.cabvi.org/catalog And imagine 31000 products on a traditional site. Link to comment Share on other sites More sharing options...
dragon5 Posted July 2, 2004 Share Posted July 2, 2004 Could someone explain eholme's post a little better? Like, how do I do this? :) Thanks d5 Link to comment Share on other sites More sharing options...
user99999999 Posted July 3, 2004 Share Posted July 3, 2004 Not every field just the ones that need it. Here is some from another thread. alter table categories add index (sort_order); alter table customers add index (customers_email_address); alter table orders add index (customers_id); alter table products add index (products_model), add index (products_price), add index (products_date_available), add index (manufacturers_id); alter table products_attributes add index (products_id), add index (options_id); alter table products_options add index (products_options_name); 3. A Linux apache server might be faster (no php cgi) than your Windows NT IIS server, but I don't want go down that path of discussion. Check this info about php on windows. Zend WinEnabler Link to comment Share on other sites More sharing options...
Guest Posted July 3, 2004 Share Posted July 3, 2004 you are going to kill yourself if you index every single field in the table, it starts taking overhead, not worth it at all. Link to comment Share on other sites More sharing options...
asapcustoms Posted February 8, 2007 Share Posted February 8, 2007 This really helped speed up the shop but our index page is still loading extremely slow in our catalog www.asapcustoms.com/catalog/index.php Maybe someone could spot our error? Thanks Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.