Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

2.3 Admin Categories.php Timing Out


RMD27

Recommended Posts

So I added a few thousand categories and now the categories page in the admin is not loading properly. It times out.

 

I could increase the time out limit but I think 60 seconds should be more than enough!

 

I tried this from 2.2 http://addons.oscommerce.com/info/4083

 

And it does not work with 2.3

 

I have tried commenting out the drop down menus at the top of the page with no joy.

 

Basically I need the table to show up only because I want to be able to delete categories.

 

What can I do to speed up the admin/categories.php?

Link to comment
Share on other sites

Tried this - http://www.oscommerce.com/forums/topic/303628-compressing-pages/
no difference.

Tried this - http://www.oscommerce.com/forums/topic/311675-gzip-compression-in-admin/
no difference.

I am an amateur so maybe I am talking out of my backside here but bare with me!

I dont think the issue is with the size of the page but with all the queries that my database is being hit with because of all the categories and sub categories.

I dont need the first layer of categories to pull any subcategory info so all those queries can be cut out, I just need to know how to do it.

Once I go down a level all is okay, but looking at the first levels categories is too much.

 

---------
This does the trick on 2.2 http://addons.oscommerce.com/info/4083 but not on 2.3

Link to comment
Share on other sites

  • 3 months later...

One way is to upgrade to a faster server. If you don't want to do that, you could cache the function that's taking too long to load. This will probably be a products or categories pulldown. You can find out which one it is by commenting each one out in turn until the page loads.

 

Regards

Jim

See my profile for a list of my addons and ways to get support.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...