Query Help....SLOW oscommerce site!!!

[lstra]

Hi,

 

My oscommerce site is running incredibly slow.....I have searched and searched the forums and have installed all of Chemo's speed up contributions including page cache and MS3 tax class. So I decided to post to SLOW queries from one page and see if anyone can help:

 

ANY HELP MUCH APPRECIATED!!!!

 

1 select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '3619' order by c.sort_order, cd.categories_name /home/****/public_html/product_info.php

 

0.600651 2007-03-09 14:16:39

 

02 select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '3301' order by c.sort_order, cd.categories_name /home/****/public_html/product_info.php

 

0.967604 2007-03-09 14:16:35

 

03 select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '906' order by c.sort_order, cd.categories_name /home/****/public_html/product_info.php

 

0.789489 2007-03-09 14:16:31

 

04 select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '763' order by c.sort_order, cd.categories_name /home/****/public_html/product_info.php

 

0.810737 2007-03-09 14:16:29

 

05 select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '2615' order by c.sort_order, cd.categories_name /home/****/public_html/product_info.php

 

0.560654 2007-03-09 14:16:24

[Nullachtfuffzehn]

Have you ever checked the state of your database? You might want to optimize/repair the tables. Only a proper database can work with full speed.

[♥FWR Media]

Istra

 

Post your web address please. I'll have a look.

 

Is your category count turned off btw because it should be.

[lstra]

Istra

 

Post your web address please. I'll have a look.

 

Is your category count turned off btw because it should be.

 

Hi,

 

Category count is set to false.

 

Website is www.partfinder.net

 

Thanks in advance,

 

Luke

[♥FWR Media]

Is this site live Luke?

[lstra]

Is this site live Luke?

 

Yes

[♥FWR Media]

Even the root index.php is very slow to load so its not just a slow query problem imo.

 

Get rid of crafty syntax a sec that tends to slow pages down.

[♥FWR Media]

Basically this seems to me a problem outside of osc.

 

Maybe a server configuration problem?

 

Have you made changes to the server or .htaccess recently?

[lstra]

Even the root index.php is very slow to load so its not just a slow query problem imo.

 

Get rid of crafty syntax a sec that tends to slow pages down.

 

ok....i removed crafty syntax....page load time has improved slightly!

[♥FWR Media]

Crafty syntax wasn't the problem (although I'd confine it to a single page e.g. contact us) try putting a simple php file in root like ..

 

phpinfo.php . containing

 

<?php

phpinfo();

?>

 

and speed test that file

[lstra]

http://www.partfinder.net/phpinfo.php

 

Works fine....very fast.

[♥FWR Media]

Probably not the server then.

 

I don't have server access so I can't help further.

 

If it were me I'd concentrate on /includes/application_top.php initially and put a die('Got to here'); line in and keep moving it until I found the slow spot.

 

I'm sure there is a far more intelligent method, but it's all I can think of atm.

 

Got to go to bed, good luck.

 

Rob

[♥bruyndoncx]

can you check your categories and categories_description table and post the indexes on these tables.

 

I would make sure to have an index like this:

 

create index cat_parent on categories (parent_id)

 

to speed up the selection of the category.

[Guest]

things you could do is to use a thumbnailer and locate where the delay comes from first before start installing modules. If you suspect the categories/products change the catalog\includes\column_left.php, comment out the categories.php box file and go to a page like shipping.php see if it still loads slow.

[Dragonkeeper]

I had the same problem that just began this week. My site became intolerably slow to load. I checked quite a few things including hounding my

webhost but, in the end, it came down to turning off the Display Category Counts. I must have passed some sort of threshhold this week

when adding new stock to my site as I did not have a problem before. But, when the number of items in my inventory pushed past the

9,000 mark, the display of the site slowed to worse than a crawl. It took about 30 seconds just to load and display the home page. Turning

off the Display Category Count returned the site to normal speed.

Gary

 

http://www.southweststamps.com