Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a voting application. This voting process takes about 3 hours to complete. After 3 hours there will be 2 millions of records in the database. At the same time application needs to query the current data. The number of votes when close to 1 million, application takes about 15min to query the current data.

I'm using MySql under Linux. There are 7 columns in the main table and there are different kind of queries to show the data and generate reports. It works well up to 1 million of records. Now I create reports every 5 minutes and, when request a report from GUI, just dump the latest report.

So what kind of a database I should use or solution for this?

share|improve this question

closed as not a real question by Gaius, Mark Storey-Smith, Nick Chammas, gbn, Martin Smith Feb 13 '12 at 12:19

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

1  
You could use anything. Your requirements aren't specific enough to narrow it down to an appropriate platform. What database systems are you most comfortable with? Do you need ACID guarantees? Is your data suitable for normalization? –  Nick Chammas Jan 18 '12 at 20:31