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

Submitter:  Sebastien MAYER <sebmay>
Submitted:  Thu 12 Sep 2002 09:20:25 PM UTC
   
 
Category:  tts Item Group:  SVN trunk (dev code)
Severity:  4 - Important Priority:  3 - Low
Status:  None Privacy:  Public
Assigned to:  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>
Group 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>

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

 

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 None
2002-09-16 skwashd CategoryNone None

Back to the top

Powered by Savane 3.13-02a9.
Corresponding source code