I process some 300,000,000 input records and store resulting 90,000,000 records during the course of a run.
When the resulting table resides in the same database as the input it takes ~20 sec per a day worth of input data.
When I use different database on the same server using the same physical drive the very same process takes ~150 sec per day.
Both databases are not in use by anybody else.
Any hint on how to improve the situation would be appreciated.