Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Category Page takes forever to load...  (Read 3178 times)

0 Members and 1 Guest are viewing this topic.

DefenceTalk.com

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 230
    • http://www.defencetalk.com
Category Page takes forever to load...
« on: June 13, 2004, 08:47:17 pm »

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]
Logged
(http://www.defencetalk.com/pictures/signature_cpg.php)

DefenceTalk.com

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 230
    • http://www.defencetalk.com
Re: Category Page takes forever to load...
« Reply #1 on: June 14, 2004, 05:51:45 am »

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

thanks
Logged
(http://www.defencetalk.com/pictures/signature_cpg.php)

hyperion

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Posts: 1317
  • - retired -
Re: Category Page takes forever to load...
« Reply #2 on: June 14, 2004, 06:17:03 am »

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.
Logged
"Then, Fletch," that bright creature said to him, and the voice was very kind, "let's begin with level flight . . . ."

-Richard Bach, Jonathan Livingston Seagull

(http://www.mozilla.org/products/firefox/buttons/getfirefox_small.png)

DefenceTalk.com

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 230
    • http://www.defencetalk.com
Re: Category Page takes forever to load...
« Reply #3 on: June 14, 2004, 06:31:24 am »

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

thanks
Logged
(http://www.defencetalk.com/pictures/signature_cpg.php)

hyperion

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Posts: 1317
  • - retired -
Re: Category Page takes forever to load...
« Reply #4 on: June 14, 2004, 07:39:00 am »

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?
Logged
"Then, Fletch," that bright creature said to him, and the voice was very kind, "let's begin with level flight . . . ."

-Richard Bach, Jonathan Livingston Seagull

(http://www.mozilla.org/products/firefox/buttons/getfirefox_small.png)

Tarique Sani

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 2712
    • http://tariquesani.net
Re: Category Page takes forever to load...
« Reply #5 on: June 14, 2004, 08:30:31 am »

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....

Logged
SANIsoft PHP applications for E Biz

DefenceTalk.com

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 230
    • http://www.defencetalk.com
Re: Category Page takes forever to load...
« Reply #6 on: June 20, 2005, 03:36:20 am »

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!
Logged
(http://www.defencetalk.com/pictures/signature_cpg.php)
Pages: [1]   Go Up
 

Page created in 0.022 seconds with 20 queries.