Which Database to use?

[juanchoc]

Hi!
Im developing a financial trading platform, and after some trouble im considering using a database for storing my backups.

Untill now i've been using binnary files and a direct access algorithm to get the position of the data directly, but as the development continues, it's getting harder and harder to use it, and using a database would really help the development process, but probably would also degrade performance.

So im trying to figure out what database technology to use.
Budget is not a problem, so im open to sugestions.

My main concern is performance.
Each of my files store 2 columns and aproximately 550.000-600.000 rows.
Until now there are about 50 files like that, so 30.000.000 records and growing fast.

Any ideas?

Thanks in advance,
JCC

[DanielaTm]

look at:

http://www.codeguru.com/forum/showth...61#post1420361

[davide++]

Hi all

You have to manage a big quantity of data, which will grow up in future.
So I suggest Oracle or SqlServer; probably the best choice is SqlServer, because Oracle is a really complex product: I usually work with Oracle, I've never worked with SqlServer, but I think Oracle is harder to manage than SqlServer, so you might use the simpliest product to solve your problem.

[cjard]

Both oracle and sqlserver have "express" editions that are focused on portability and local use rather than multiclient/networkserver architecture