Hi All,

I did a quick search through the forum, however I couldn't find an answer to what I'm after, so I have a question for you all I hope this isn't the wrong section... I need to implement a free database system that is both fast and scalable. I anticipate for the data we will end up having, the databases will store in total, over 100 trillion rows of data.

There will basically be a bunch of servers in one rack generating data and inputting it into the database at ~10,000 records per second, then a website on the intranet allowing research staff to input a string, which the database will be searched for. So the only functions we really need are very simple(INSERT, UPDATE, SEARCH), however due to the amount of data I would anticipate we would need to spread the data across multiple databases and tables across multiple servers. At the moment we have about 6 x Dual Quad Core Servers put aside for database servers, however we are open to expansion if the need arises(no doubt it will). The searching needs to take less than 20 minutes per query, with up to 10 queries happening simultaneously.

So can anyone recommend a good free database system? Or is that not really possible? I'm thinking MySQL or PostgreSQL as they are the only two I have dealt with apart from MSSQL.

Also, it would be best if it ran on linux....

Thanks!

How many concurrent users are we talking about here?

How many fields, and of what kind, are to be searched for?

Can you give up a better idea as to the kind of data you're discussing? And, its structure?

What kind of indexing in anticipated? You mention text data.

Hi,

I have a similar issue. I'm looking for a free solution with the following requirements:

- hosted on MS Server 2003
- accessed by 4-5 clients/users
- less than 5000 entries
- ~10 Text fields per entry
- most of the fields should be indexed/searchable

Any advice is very welcome.

Thanx!