Hi list Did you make 'index' on your table?
make index like this: CREATE INDEX index_name ON table_name(field_name); i.e. CREATE INDEX username_index ON TableUser(username); and you'll get result in 0.x seconds! ----- Original Message ----- From: "Asma Aripin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, July 12, 2002 2:41 PM Subject: Processing Time > > > > ---------- > 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 > > --------------------------------------------------------------------- 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
