This may not be the solution you are looking for, but if you are executing ths query 1000 times, it must be in a program somewhere, so why not execute it once, pullout the UserID the run the rest on UserID?
Hope this helps. Roger -----Original Message----- From: Jason West [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 1:40 PM To: [EMAIL PROTECTED] Subject: Searching on indexed char field... Does anyone know of a way to speed up seek time when selecting based on an indexed char field? I have a query that I'm executing ('select * from Table where UserName = myname') and it takes approximately 7 seconds to execute this 1000 times (UserName is char[50], and it is indexed). If I change the query to search on UserID, an indexed integer field, the same test runs in less than 1 second... Any help is appreciated... -- Jason H. West Software Engineer Softek Software International, Inc. 813 Pavilion Ct. McDonough, GA 30253 678-583-5718 [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
