MySQL Forums :: Newbie :: New to design; how to optimize 3 column single table with high I/O?


Advanced Search

New to design; how to optimize 3 column single table with high I/O?
Posted by: Marie Sutherland ()
Date: July 10, 2011 08:58PM

I am newer to db design; I've done a lot via GUI/PHPmyAdmin, but now I need to get a bit deeper.

Imagine a very simple DB with 3 columns: User ID, Yes/No, Time.

User ID is one of several thousand possible.
Current State is a dummy variable; Yes or No.
Time is the time this record was inserted down to the millisecond.

The query coming from the app will look like this:

For User X at Time X, Yes or No?

This db will need to be indexed on userid/timestamp, I think.

Imagine several million of these records, lots of records per user per event I'm tracking.

Is there any better/faster way to do this besides the very simple query I have above? I am open to all suggestions, including using another OSS db than MySQL,if necessary.

Options: ReplyQuote


Subject Written By Posted
New to design; how to optimize 3 column single table with high I/O? Marie Sutherland 07/10/2011 08:58PM
Re: New to design; how to optimize 3 column single table with high I/O? Rick James 07/11/2011 10:13PM
Re: New to design; how to optimize 3 column single table with high I/O? Marie Sutherland 07/11/2011 10:31PM
Re: New to design; how to optimize 3 column single table with high I/O? Rick James 07/11/2011 11:51PM


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.