MySQL Forums
Forum List  »  Performance

Storing and fast retrieving of Email address
Posted by: Carlo Carlo
Date: March 17, 2008 04:42PM

Hi All,
I have a large table (3.4M rows) that contains users informations.
The primary key is the Email address, indexed, and I want to speed-up the query time.
I'm thinking to change the email field from plain text to some other datatype, like an Hash or a numerical value.
Can anyone help me to find a correct and fastest datatype?

p.s. The tipycal query is quite simple: SELECT filed1, field2,field3 FROM Users WHERE email ='123@123.com'


Thanks,
Carlo

Options: ReplyQuote


Subject
Views
Written By
Posted
Storing and fast retrieving of Email address
10767
March 17, 2008 04:42PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.