-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Asma Aripin wrote: | | | | ---------- | I want to select 1 record from 200,000 rows of records. I use this SQL | statement: | | SELECT password FROM TableUser WHERE username='jack00' | | It takes me about 20 seconds just to view the password. | | Is there any other way to decrease the time? (In about less then 1 second) | ---------- | Thanks & Regards, | Asma Binti Aripin | R&D Department - [TelCo:CELCOM] | Messaging Technologies Sdn Bhd | Tel. (O): 0376651101 ext. 121 | Tel. (H): 0132316056 | Email : [EMAIL PROTECTED] | | ----------
Does the "username" column have an index? See http://www.mysql.com/doc/I/n/Indexes.html -Mark -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6-2 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE9LrSFlyjUJM+7nP4RAqG3AJ9AIsBM21xf1uY0T6SghH5Uh7Ep1ACdEuxm rVSn0yxp6hd9P0YR3cPqmcA= =LDRV -----END PGP SIGNATURE----- --------------------------------------------------------------------- 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
