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