Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  Bulk Insert

Author  Topic  Brad Starting Member 13 Posts Posted - 2000-12-07 : 14:50:42 I've been having problems with the performance on a bulk insert of 100,900,000 rows. The table has only a 65 byte record length. The input file is about 4.23 gigs. It takes about 10 hours to run. Does anyone have any ideas? I've tried playing with ROWS_PER_BATCH making it 1000000 and it seems to help. Does anyone know the optimal batch size? BULK INSERT People.DBO.Person FROM 'e:\People\People.txt' WITH ( TABLOCK, FORMATFILE = 'e:\sqldata\People.fmt', ORDER (Zip Asc), ) The system: Windows 2000 SQL Server 2000 4 PentiumIII 400MHZ Xeons with 1 meg cache 2 gigs of RAM. I don't see why it should take anymore than a couple of hours. I can load a table with the same number of records with 7 times the record length in about 10 hours.