aperfecthost Posted May 15, 2003 Posted May 15, 2003 After adding about 2000 products, the site has become unreasonably slow. Is there anything that can be done to increase the speed of the site (short of deleting products!!) (actually probably 1000 products but most are listed in 2 categories) Thanks.
Druide Posted May 15, 2003 Posted May 15, 2003 disable category counts and you will be in good shape again Robert We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;)
Daemonj Posted May 16, 2003 Posted May 16, 2003 Adding indexes for category name, product name, and manufacturer name will also be of benefit as will optimizing the tables. In addition, enabling GZip compression with a setting of 1 and using the cache will also help. "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein
Guest Posted May 16, 2003 Posted May 16, 2003 How do i teak the gzip settings? I have installed the contribution but cannot find settings. Also any information on how to go about indexing etc would be appreciated. I also change application top to set the show counts to false but when i did that, some of my categories showed numbers at the side at them. Any help on making the performanace of the site better would be appreciated. Regards PR
Daemonj Posted May 16, 2003 Posted May 16, 2003 Are you using MS1 or a CVS version? If a CVS version, how old is it? In the newer versions, the GZip settings can be set in Admin ~ Configuration ~ GZip compression. In the older versions, I believe the compression setting was set in includes/application_top.php but do not recall offhand. Use a setting of 1 to gain the most benefit. The category counts setting should be in Admin ~ Configuration ~ My store. When set to false there should only be arrows next to your categories, not numbers. I have the following in a file called create_indexes.sql that I import into each database. Instead of creating a file, just copy it into a PHPMySQL SQL window. 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); "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein
Guest Posted May 16, 2003 Posted May 16, 2003 I added the sql. I looked for gzip but couldnt find anywhere to add the "1" you mentioned. I think im running an older OSC. How can i find out and how do i upgrade, will it affect all the work ive done? My main problem is that it seems to take a while for the main page to load or be displayed. Any ideas? Thanks in advance. PR
Guest Posted May 16, 2003 Posted May 16, 2003 Loading time results for: http://www.domecomputers.co.uk/ Loading test content results Number of graphics/scripts: 107 Total graphics size: 55866 bytes Total HTML size: 32601 bytes Total page size: 88467 bytes Load time by modem speed Modem speed: Download time: 14.4k 53.49 seconds 28.8k 28.9 seconds 56k 16.84 seconds ISDN (128k) 9.85 seconds T1 (1.44 MB) 4.83 seconds Warning!: Your loading time is not bad... However, a top performing web site will load under 14 seconds at 28.8k. The_Bear
Guest Posted May 16, 2003 Posted May 16, 2003 Yes thats without the mainpage. It almost doubles. I know i can get it below that though. Why dont things load sequentially, so you can see them load as opposed to everything being displayed in the one go. Regards PR
Daemonj Posted May 16, 2003 Posted May 16, 2003 That is due to the output buffering which actually improves your sites speed but seems slower. Instead of sending multiple packages of small data, output buffering sends all of the information at once fully utilizing the bandwidth and reducing the amount of traffic. Look for a setting in configure.php or application_top.php that is defined as GZip compression level. It should have a numerical setting from 1 to 9 and is probably set at 3 or 5. Whether or not to upgrade to a newer version is really dependent upon how many and what mods you have installed. "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein
Guest Posted May 16, 2003 Posted May 16, 2003 I cant find anything to do with gzip except the contribution i installed and that doesnt specify a number. Also where in configure is the bit to specify the path for caching. I changed this in admin but it says "Error: Cache directory does not exist. Please set this in configure.php." Ive looked for it but cannot find it. Do you know the exact syntax to add? Does upgrading the site mean reverting back to the unmodified osc? or can i just upgrade file to include new bits. Regards PR
Daemonj Posted May 16, 2003 Posted May 16, 2003 Make sure that your cache folder is in your webspace (i.e. /home/[user]/tmp/) and not the server's webspace (/tmp/) or you will have not end of problems. You also have to give that folder 777 rights. The setting for the cache folder shoud be in application_top.php instead of configure.php but I no longer remember. :( I have become used to it being a part of the admin. It should be something like: define('DIR_FS_CACHE', '/home/[users]/tmp/'); or something very close to that. Be sure to include the / at the end. Upgrading would involve reverting back to stock osC and then having to reinstall any contributions that you have put in. Also keep in mind that a lot of the functionality that used to require a contribution is now built in. Personally, I would upgrade but I am not familiar with what you have done to your existing site nor what your timeline is. "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein
Guest Posted May 16, 2003 Posted May 16, 2003 Sorry to hassle you but im thinking more of upgrading now. As i have recognised that the contributions i have installed would be easier to do. Anyway ive got a empty OSC site oon another domain. Do i just download the latest version and copy all files from here to the server to overwrite the existing ones? Regards PR
Daemonj Posted May 16, 2003 Posted May 16, 2003 If you site is empty, your best bet would be to delete the files and the database. Download a current CVS version and install it. That way you do not have to worry about any old files and/or settings getting in the way. I assume that your products are in another osC database or somewhere else? Let me know on that and I'll tell you how to get them into the new database. "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein
Guest Posted May 16, 2003 Posted May 16, 2003 Ok heres how im going to set it up. My original site is www.domecomputers.co.uk I have domecomputers.com - i am going to set some webspace up for this etc and ive got 2.2ms1 and am going to install it. - is this the right version? I have products in the dome.co.uk database and will need to get them (and the images) into dome.com database. Is there any warnings / tips you coudl give me before i start this whole procedure. Thanks in advance PR
burt Posted May 16, 2003 Posted May 16, 2003 Jim. Many thanks for posting those .sql alters. Appreciated.
Daemonj Posted May 16, 2003 Posted May 16, 2003 burt, I hope that they are of some use to you. :) proy, I would grab a 2.2 CVS version instead just to catch a lot of the new features that are missing from MS1. Do you have access to PHPMyAdmin on both of your domains? If so, the easiest way to get the information from your old database into your new database is to perform the following steps: At your old domain: 1. Open PHPMyAdmin, select the database, and click the export tab. 2. Select the following tables: categories categories_description manufacturers manufacturers_info products products_attributes products_attributes_download products_description products_notifications products_options products_options_values products_options_values_to_products_options products_to_categories 3. Select data only 4. Select complete inserts 5. If you have the option, select to save as file and save it to your hard drive. Then at your new domain: 1. Open PHPMyAdmin, select the database, and click the sql tab. 2. Copy the insert statements that I provided earlier in this topic and click ok. 3. Click the browse button and select the file that you saved of your data and click ok. 4. Click the database name in the left-hand column to get the table list in the right-hand pane of the screen. 5. Click the select all link and select optimize from the drop-down and say ok. Now you just have to go through the Admin panel and set your settings. Let me know if you have any problems. "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein
Ajeh Posted May 17, 2003 Posted May 17, 2003 Might want to add specials, reviews and reviews_descriptions to that list, Jim
Daemonj Posted May 17, 2003 Posted May 17, 2003 Might want to add specials, reviews and reviews_descriptions to that list, Jim Good point Ajeh. Thank you for picking those up. :) "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein
Ajeh Posted May 18, 2003 Posted May 18, 2003 You got the majority of them ... I just remember those because I just moved a site ... :wink: Thanks for the list. That will really be helpful. You might pop that list into Tips and Tricks too.
Daemonj Posted May 18, 2003 Posted May 18, 2003 Which list, the one to create indexes or to move products from one database to another? "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein
Ajeh Posted May 18, 2003 Posted May 18, 2003 Actually both ... post them as seperate tips with good titles ... 8)
Genius Posted March 23, 2004 Posted March 23, 2004 HI by adding the indexes list , does that make the admin section faster , also i have been trying to find the full list of what needs to be indexes.. and no such luck.. could someone please help me on this... many thanks
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.