Quote:> Do you have such experience (with one table with so much records) ?
> I need info to be able to make right decision on current project. Thanx.
I worked on db optimization project for the biggest mobile phone services
provider in our country. All records from phone switches are imported to SQL
Server for billing and analysis and we are talking about 100 000 000 records
per month. And BTW, those records are much longer, not just ten columns
(from your description I suppose you are talking about 50GB of data, I had
nearly 100GB per month).
To persuade the customer that SQL Server is the right solution, I tested the
speed you can reach for inserts. On my desktop, one processor, one disk,
over LAN, nothing done for HW optimization, I succeeded to insert 2 000 000
rows in 10 minutes on SQL 7.0. So I suppose with better HW, using filegroups
etc., it is possible to do it ten times faster.
Anyway, be aware that dealing with so huge databases is not fun.