bugweb-cyradm - Bugs: bug #11845, Missing index on log table

 
 

bug #11845: Missing index on log table

Submitted by:  Thomas Neidhart <tneidhart>
Submitted on:  Fri 04 Feb 2005 10:31:25 AM UTC  
 
Category: sqlSeverity: 3 - Normal
Priority: 5 - NormalItem Group: normal bugs
Status: FixedPrivacy: Public
Assigned to: Luc de Louw <delouw>Originator Name: Thomas Neidhart
Open/Closed: ClosedRelease: 0.5.5
Operating System: NoneReproducibility: Every Time
Planned Release: NoneCyrus IMAP version: None
PHP version: 4.3Database type: MySQL 4.0

Add a New Comment(Rich Markup)
   

You are not logged in

Please log in, so followups can be emailed to you.

 

Fri 04 Feb 2005 10:31:25 AM UTC, original submission:

If the log table increases very much the browseaccounts.php will get very slow. After setting the following index it works good.

ALTER TABLE `log` ADD INDEX `idx_log_user` ( `user` );

Thomas Neidhart <tneidhart>

 

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

Attach File(s):
   
   
Comment:
   

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 click here to add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.

 

Please enter the title of George Orwell's famous dystopian book (it's a date):

 

 

Follow 4 latest changes.

Date Changed By Updated Field Previous Value => Replaced By
Sun 10 Jul 2005 02:00:54 PM UTCdelouwStatusNone=>Fixed
  Assigned toNone=>delouw
  Open/ClosedOpen=>Closed
  Release0.5.4=>0.5.5

Back to the top


Powered by Savane 3.1-cleanup1