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...
If you're indexing all 50 characters, index fewer of them.
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
