Zikula Community

• bronto
  
  

  • Rank: Helper
  • Registered: Dec 31, 1969
  • Last visit: May 07, 2010
  • Posts: 507

  Posted: Jun 10, 2010 - 10:20 AM

  We're testing functionality after upgrading from 1.1.2 to 1.2.3.
  
  All goes well so far except for a module that has a function using pnUserGetAll(). We have a 7800 user database, and it takes about 2.5 minutes to execute this. I've run it through the debugger and pnUserGetAll is definitely the issue. The drag starts at:
  
  return DBUtil::selectObjectArray('users', $where, $sortby, $startnum, $limit, 'uid');
  
  It returns valid data, but the function isn't usable as it is.
  
  Suggestions?

  • 
  •  
• bronto
  
  

  • Rank: Helper
  • Registered: Dec 31, 1969
  • Last visit: May 07, 2010
  • Posts: 507

  Posted: Jun 10, 2010 - 10:21 AM

  BTW, I've confirmed that it only took about 5 seconds to run in 1.1.2. Probably having something to do with attributes?

  • 
  •  
• bronto
  
  

  • Rank: Helper
  • Registered: Dec 31, 1969
  • Last visit: May 07, 2010
  • Posts: 507

  Posted: Jun 10, 2010 - 12:03 PM

  Code search reveals that there's a Pagesetter plugin, pnUsers, that uses an unfiltered pnUserGetAll that's a performance killer as well. I've been wanting to hack that anyway to limit the users to just one group, so I've done that and it's working OK. But thought someone else might want to know this. I don't remember where I got the plugin, I don't think I wrote it, it doesn't look like my code.
  
  Also, the module CoDoc uses an unfiltered pnUserGetAll, but while we have that installed we don't use it.

  • 
  •  
•  
•  

Users on-line

• 0 users

This list is based on users active over the last 60 minutes.