Tell me more ×
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.
up vote 2 down vote favorite
1

We have to launch a new service in my company with a big database.

And I currently don't have that much knowledge.

We did a small preview of the service and our biggest table had more than 2 100 000 rows. Our second biggest table had 300 000 rows.

Currently our database if only 15GB but the final one will be at least 75 times bigger.

And no need to say that we need to access to our database very quickly and to run queries quickly as well.

What's your advice about our infrastructure (One big server or several servers) and what database system should we use ?

share|improve this question
1  
There are too many factors that influence this kind of decision. Size of data is just one of them (and it would be more simple to list systems, which are not suitable for your needs). If there is no one esle in your company, who would be able to answer or give advice, the best you can do, is hire someone. – ipip Jun 24 '12 at 19:31
What database system are you using now? What expertise do you have in your company? Do you really think 2 million rows is big? – Aaron Bertrand Jun 24 '12 at 21:28

1 Answer

up vote 2 down vote

I would recommend trying PostgreSQL to be honest. You can always move away later but that's a good place to start. It's free. It's not a db specializing in running code written for other db's (like MySQL is). It is enterprise-grade. It is advanced and you can take the features it offers and go very far. With regard to advanced data modelling it is on a par with the best commercial RDBMS's though in some other areas it is not there yet.

It is hard to know though given how vague your requirements are.

The key thing you always need to keep in mind is that your key constraints are:

1) What sort of data are you gathering? and 2) What do you intend to do with it?

If you are not going to just try a bunch of options and see what works best, then you need to carefully consider those two questions.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.