MySQL Forums
Forum List  »  Newbie

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?
July 10, 2011 08:58PM


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.