----------
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]
----------
---------------------------------------------------------------------
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