Skip navigation links

MySQL Forums :: Performance :: Storing and fast retrieving of Email address


Advanced Search

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 9889 Carlo Carlo 03/17/2008 04:42PM
Re: Storing and fast retrieving of Email address 3691 Phil Hildebrand 03/20/2008 08:21AM
Re: Storing and fast retrieving of Email address 2869 Carlo Martinez 03/25/2008 05:54PM
Re: Storing and fast retrieving of Email address 2536 KimSeong Loh 03/25/2008 07:34PM
Re: Storing and fast retrieving of Email address 2343 Rick James 05/29/2008 09:53AM


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.