I'm using VS 2005 Beta 2. My application loads data from text files into a DataSet and uploads the DataSet to a SQL Server. In my TableAdapter, I'm setting the UpdateBatchSize = 0 (the maximum the server can handle), hoping to increase performance. But when the adapter is uploading the data, I see a huge increase in memory consumption for each table (around 300 MB).

So my question is, what is a good compromise between performance and memory requirements? 32? 128?