The admin section of my site is super slow....

[Guest]

Any time I need to edit things in the catalog section of my admin, it takes about a minute between each click of the mouse before I can move to the next step. The category column (where I can move, edit, delete, etc in particular categories) is the only part that I have trouble with. My site has over 12,500 products but I keep seeing posts about how OsCommerce can handle any number of products. Any way to figure out just why it takes so long to be able to do anything?

 

Thanks!

www.better-beads.com

[MoisesZaragoza]

Well the arson why it takes too long is because how big your site is.

 

OSC can handle any number of products but is all how fast you can search the Database

 

that is a normal probably with that many products

 

 

PS you are showing Current Parse Time: 0.312 s with 25 queries at the bottom of the page

[Guest]

Well the arson why it takes too long is because how big your site is.

 

OSC can handle any number of products but is all how fast you can search the Database

 

that is a normal probably with that many products

PS you are showing Current Parse Time: 0.312 s with 25 queries at the bottom of the page

 

Well, thanks for the response but I am unsure of what the Parse Time and Queries from the catalog section of my site have to do with my ADMIN catalog section being slow.

 

I have had this installed (OS) for going on a year now and it has all the sudden starting being slow. I've always had over 12,000 items so I am not quite understanding why all the sudden NOW my admin catalog section would start being slow.

 

So, question still stands. Anyone else have this problem and anyone know how to fix it or find out specifically what could be causing it?

 

Thanks!

[Guest]

Well, thanks for the response but I am unsure of what the Parse Time and Queries from the catalog section of my site have to do with my ADMIN catalog section being slow.

 

I have had this installed (OS) for going on a year now and it has all the sudden starting being slow. I've always had over 12,000 items so I am not quite understanding why all the sudden NOW my admin catalog section would start being slow.

 

So, question still stands. Anyone else have this problem and anyone know how to fix it or find out specifically what could be causing it?

 

Thanks!

 

Might be worth checking with your Webhost to see if there is any planned or on-going maintenance with your database server ?

[Guest]

Is the performance degradation on certain parts of the admin section or generally on every script? For example, on stores with lots of orders that particular section (and the customers) will be slow. Or, those with lots of products will see a speed decrease when administrating the catalog.

 

Give some more details but the answer will most likely be that you need to add proper indexes on your database for faster query exectution.

[AussieGirl]

One of my websites got up to 35,000 products and the admin section started to get amazingly slow when doing anything with the categories.php file. What I ended up doing was commenting out the following line of code:

 

$category_products = array('products_count' => tep_products_in_category_count($categories['categories_id']));

 

and putting the following code into the delete_category area of the code:

 

$category_childs = array('childs_count' => tep_childs_in_category_count($cID));

$category_products = array('products_count' => tep_products_in_category_count($cID));

 

$cInfo_array = array_merge($categories, $category_childs, $category_products);

$cInfo = new objectInfo($cInfo_array);

 

Just before the following code:

 

if ($cInfo->childs_count > 0) $contents[] = array('text' => '<br>' . sprintf(TEXT_DELETE_WARNING_CHILDS, $cInfo->childs_count));

 

My code is heavily modified so I don't want to post the whole file here, but what this does is it means that the number of Products is not displayed under the number of sub categories for each category you are viewing (over on the right hand side of the page). The number of products does however display when you are deleting eg:

 

WARNING: There are 325 products still linked to this category!

 

I hope this helps.