Hi all,

With a very large amount of data I mean 100 million records!

When I try to select some data, it needs quite a time to execute.

Currently I use MySQL5.1. I also created indices where necessary. Is there anyway to speed up things? Or should I go for a different sql server (MS SQL server, Oracle, ..?).

I read some articles about different SQL servers and its speed, but all articles have a different opinion about what the fastest is.

What is the best thing to do in this case?