bugNSS MySQL - Bugs: bug #4192, Nonsensical join

 
 

bug #4192: Nonsensical join

Submitted by:  Invalid User ID <Invalid User ID>
Submitted on:  Fri 04 Jul 2003 01:30:18 PM UTC  
 
Category: NoneSeverity: 3 - Normal
Item Group: NoneStatus: Need Info
Privacy: PublicAssigned to: Guillaume Morin <gmorin>
Open/Closed: Closed

Add a New Comment(Rich Markup)
   

You are not logged in

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

 

Tue 08 Jul 2003 04:27:57 PM UTC, comment #2:

Marcus,

Can you try the CVS version and tell me if it is better ? There is actually some room for improvement. The single query nss-mysql appears to be slow. Splitting it in two has been reported to be much faster. But I've not had the time to change that. I am not even sure this is the way to go since newer MySQL versions might handle this one more appropriately.

Guillaume.

Guillaume Morin <gmorin>
Project AdministratorIn charge of this item.
Mon 07 Jul 2003 01:48:12 PM UTC, comment #1:

Marcus,

It is an ipop issue. NSS MySQL implement the NSS API so I guess ipop calls getgrent which returns all results. I am still maintaining the project. I have moved to a new job
(and a new country) so I have been very busy recently.

What I suggest is to try the CVS version which should be faster and try to install nscd. Some people have reported problems with it and some said it works flawless. You might want to give it a try.

You can also use the MySQL "EXPLAIN" command to see if the query you pasted makes a good use of indexes.

Guillaume.

Guillaume Morin <gmorin>
Project AdministratorIn charge of this item.

 

(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
Mon 21 Feb 2005 11:39:53 PM UTCgmorinStatusInvalid=>Need Info
  Open/ClosedOpen=>Closed
Mon 07 Jul 2003 01:48:12 PM UTCgmorinAssigned toNone=>NA
Mon 07 Jul 2003 01:48:11 PM UTCgmorinStatusNone=>(Error - Not Found)

Back to the top


Powered by Savane 3.1-cleanup1