INSERT performance on large table.

I have a user who wishes to initially load 4 million rows on a table. After this he will insert 4000 per day. I don't like this approach. I would like to maintain a small staging table and then let him have an archive area for the 4m plus rows.

A table with 4m rows in it. What is the issue of an additional 4k rows each day from a performance standpoint. Received on Mon May 14 2001 - 16:26:21 CDT