Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: User List timeout  (Read 3511 times)

0 Members and 1 Guest are viewing this topic.

roniabirk

  • Coppermine newbie
  • Offline Offline
  • Posts: 5
User List timeout
« on: February 21, 2006, 05:36:29 pm »

usermgr.php is timing out for me now that I have 15+ pages of users. I guess that is the equivalent of 300+ users.

How can I adjust the SQL query to reduce the processing time so it won't timeout? I've changed the users per page variable to 10, and that didn't help. I thought about using "Select TOP" but I don't know that it will achieve what I want either. I'm not a database guru what-so-ever.  :P

Any thoughts? I searched, and it seems like no one has been talking about the user list not loading for a few versions now, so sorry for the new topic.
« Last Edit: February 21, 2006, 08:02:14 pm by Nibbler »
Logged

Nibbler

  • Guest
Re: User List timeout
« Reply #1 on: February 21, 2006, 06:27:39 pm »

Please post a link to your site.
Logged

roniabirk

  • Coppermine newbie
  • Offline Offline
  • Posts: 5
Re: User List timeout
« Reply #2 on: February 21, 2006, 06:28:52 pm »

http://stripedwall.com/cpg/

It is registration required right now though. Do you need a login?

ETA: Hm, it seems to be taking a long time on my other site, which has about 12 pages of members. http://spy-caps.com. Also registration required. Both hosted at Dreamhost on different servers though. I haven't had problems w/ timeouts with anything else lately.
Logged

Nibbler

  • Guest
Re: User List timeout
« Reply #3 on: February 21, 2006, 06:34:53 pm »

By the looks of it you are the only/principle uploader of pics. If this is the case then check http://forum.coppermine-gallery.net/index.php?topic=27540.msg129081#msg129081
Logged

roniabirk

  • Coppermine newbie
  • Offline Offline
  • Posts: 5
Re: User List timeout
« Reply #4 on: February 21, 2006, 07:19:18 pm »

That does fix it. Why is that? I'm curious .. I guess without the index the query just takes longer, but why does forcing it help? Thanks!   :D
Logged

Nibbler

  • Guest
Re: User List timeout
« Reply #5 on: February 21, 2006, 08:01:55 pm »

I think it wants to ignore the key since all the values of owner_id are the same. I don't get this issue in MySQL5 so presumably the optimizer has been improved/fixed.
Logged
Pages: [1]   Go Up
 

Page created in 0.019 seconds with 20 queries.