[Nss-mysql-devel] [ 101504 ] id command VERY slow

[nobody]

Support Request #101504, was updated on 2002-Nov-07 22:26
You can respond by visiting: 
http://savannah.nongnu.org/support/?func=detailsupport&support_id=101504&group_id=443

Category: None
Status: Closed
Priority: 5
Summary: id command VERY slow

By: kveton
Date: 2003-Jan-09 16:59
Logged In: YES 
user_id=14541
Browser: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.3a) Gecko/20021207 
Phoenix/0.5

If you would like I can provide you with our config and db
so you can get test it yourself.  The db we have isn't
terribly large but its only going to get bigger.  We noticed
that with only a few thousand entries each of those selects
took 1.6 seconds to complete.

Thank you for such a quick response ... anything to avoid
NIS. ... :-)

Scott :-)

----------------------------------------------------------------------

By: gmorin
Date: 2003-Jan-09 10:42
Logged In: YES 
user_id=230
Browser: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.2.1) Gecko/20021226 
Debian/1.2.1-9

This can be done with multiple selects. But my tests showed
that it was slightly faster with only one request. I guess
my tables weren't big enough.

In a perfect world, one request should be faster that three
requests but looks like we're far from that :-) I wonder if
this is fixed in MySQL 4.

Anyway, I'll change that in 3 selects.

Guillaume.

----------------------------------------------------------------------
You can respond by visiting: 
http://savannah.nongnu.org/support/?func=detailsupport&support_id=101504&group_id=443