bugphpGroupWare - Bugs: bug #1192, MYSQL raise 50% CPU and httpd 45%...


You are not allowed to post comments on this tracker with your current authentication level.

bug #1192: MYSQL raise 50% CPU and httpd 45% when asking 2000 tickets

Submitted by:  Sebastien MAYER <sebmay>
Submitted on:  Thu 12 Sep 2002 09:20:25 PM UTC  
Item Group:  SVN trunk (dev code) Category:  tts
Severity:  4 - Important Priority:  3 - Low
Status:  None Privacy:  Public
Assigned to:  Lars Piepho <lpiepho> Open/Closed:  Open
Component Version:  None Operating System:  GNU/Linux - Mandrake
Reproducibility:  Every Time Planned Release:  None
Fixed Release: 

Tue 20 Jan 2004 04:14:40 AM UTC, comment #1:

I just created 30,000 contacts and the addressbook ran just fine, as far as list, add, and view contact.

Yes, there is a problem with TTS. Most of TTS needs to be re-written, its making a ton of redundent querys. This won't happen durring .16 ... I can't promiss anything for .18 either, it will happen in time.

Joseph Engo <jengo>
Project Administrator
Thu 12 Sep 2002 09:20:25 PM UTC, original submission:

In general in 14RC3, when you try to get lot of records, you notice an horrible response time.
What is lots : 2000 tickets for example.
On Linux, asking 2000 records to Mysql is just a snap. But when you ask PhpGroupware to show all tickets (closed and open) and you have 2000 of them, you simply pass the 30 seconds and get rejected by PHP. We will not increase this tempo : Just create 1000 contacts in the address book. Try to display them one shot....and get crazy.

My question : Is this solved in the .14 release ?

If not : It seems that you do like asking all records with an individual Mysql select ! Or you may read all of them one shot, but then get some linked information in another file one after the other... Like 2001 connection and selects.
Then better load all linked info in one table, then read all selected records in one select, and then do the links with PHP reading memory indiced table.

Please do the following test : create a big base ! Create 10 000 contacts ! then travel down the base...

Every guy using the addressbook does it because : he got a large amount of contact, and they are many guys to share the contacts. If it is not the case, they use the integrated address book of theire local outlook/netscape etc...

Briefly : reading into Mysql should use 1 or little number connection, and 1 or little number of select. And accept to manage numbers like many tousands as regular and normal value.

Got Comments ?

Sebastien MAYER <sebmay>


No files currently attached


Depends on the following items: None found

Items that depend on this one: None found


CC list is empty


Do you think this task is very important?
If so, you can add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.




Follow 5 latest changes.

Date Changed by Updated Field Previous Value => Replaced by
2004-01-20 powerstat Assigned toNone => lpiepho
2004-01-20 jengo Severity3 - Normal => 4 - Important
    Priority5 - Normal => 3 - Low
2002-09-17 ceb Item Group0.9.14 RC3 => (Error - Not Found)
2002-09-16 skwashd CategoryNone => (Error - Not Found)

Back to the top

Powered by Savane 3.3