At 9:54 AM -0700 8/11/02, Mike Wexler wrote: >>I would think that using the SQL shown would require a table scan, >>meaning that each and every record in the visitors table must be >>examined, the LoginPassword decoded and compared. There is also no >>way to index this field. I do not think this is the best solution >>after adding 100,000 records. > >If you have an index on EmailAddress this will not require a >complete scan. It will do a simple index lookup on the email >address. Get any matching records and compare the password on each >of these.
OK that is the answer. Thank you for the help! -- Michael __ ||| Michael Collins ||| ||| Kuwago Inc ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com --------------------------------------------------------------------- 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
