Fast data retrieval in MySQL

Posted by trojanwarrior3000 on Stack Overflow See other posts from Stack Overflow or by trojanwarrior3000
Published on 2010-04-18T16:37:06Z Indexed on 2010/04/23 20:33 UTC
Read the original article Hit count: 351

Filed under:
|
|

I have a table of users - It contains around millions of rows (user-id is the primary key).

I just want to retrieve user-id and their joining date.

Using SELECT user-id, joining-date FROM users requires lot of time. Is there a fast way to query/retrieve the same data from this table?

© Stack Overflow or respective owner

Related posts about mysql

Related posts about scaling