Category Page takes forever to load...

[DefenceTalk.com]

Lets see if anyone can spot the problem?


yes... very very very long category page and thats only 147 categories. 100 or so more will be added. Any solution to this problem? Any way to edit ONE category at a time instead of showing all at one page. Or atleast ONE TOP LEVEL category along with all its child categories? Im on DSL and it takes very long for the page to load. Please help.

thanks


[attachment deleted by admin]

[DefenceTalk.com]

any leads/hints in how to do this would also help....

thanks

[hyperion]

Hmm, some kind of pagination would probably be appropriate here.  This is done with some PHP code and adding LIMITs to the SQL queries.  You would need to get a count, then write some code that would generate links to the same page with some get variables containing the desired range appended to the URL.  Then you would validate the get varaibles and insert them as the range limit in the query. This would return a limited set.

[DefenceTalk.com]

Do i have to touch any file other than: catmgr.php and SQL ?

thanks

[hyperion]

The category manager program is mostly self-contained, though the way it is currently structured with the parent/child relationships would make the approach more difficult that just a few edits here and there. In any case, all code changes should be within that one file.

It might be better to look for a way to hide the subcatagories until they are requested. You really can't hurt the rest of Coppermine by playing with it, but you would be in trouble if the modification hurts the database. I would advise running any experiments on a different testing installation.

@Tarique:  Would you have any suggestions for an approach to this issue?

[Tarique Sani]

long with pagination,  a better UI would be to do away with the multiple drop downs (one in front of each Category), instead there should be a check box which allows categories to be selected  and have just one drop down in the last with a Move into button....

[DefenceTalk.com]

I am requesting this mod / feature to CPG.

Take a look at the screen shot. I got almost 285 categories (last time i posted in this thread the categories were 147). If you try to print it, it comes out to be about 9 pages.

Thanks!