I am working on developing a workbench to "warehouse" my organization's data on a weekly basis. The data is spatial in nature and stored in a SQL Server database. It needs to be moved to an Oracle environment on a weekly basis.
Reading the data into the workbench has been very slow, especially for one feature class that contains around 9.5 million point records. During some testing, I noticed that when I remove the writer, the read time dramatically decreases (from around 40 mins to 10 mins). Is this expected behavior? Are there any ways that I can increase the performance of reading/writing these larger datasets?