What is the largest database you have?

[pigsie]

Hi we have a potentially huge database planned (200 million+) and would be interested in hearing if anyone has had any problems with database of that size?

Thanks

 

[dr00bie]

What kind of database server are you thinking about using? I wouldn't put 200+ million records in an Access DB.

Drew

 

[pigsie]

SQL server/Oracle

 

[dr00bie]

It shouldn't be a problem. You need to make sure that your queries and stored procedures are efficient however...

Drew

 

[pigsie]

Thanks

 

[mrdenny]

At my previous job we had a couple of MSSQL databases with over 1 billion records. MS SQL was able to handle it with no problem.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[MDXer]

Previous Project had a DW on MS SQL Server with approx 2 billion records per year with 3 year history maintained. It is included in this list.

Here is a list of large MS based databases

http://www.microsoft.com/sql/evaluation/compare/wintercorp.asp#workload

Shoot Me! Shoot Me NOW!!!
- Daffy Duck