Hi,
I have a database with 160 featureclasses(tables) and a total of 170.000.000 tecords. It takes a very long time to read all te data (almost 2 days). Is it possible to use multiple readers and writers who will read/write at the same time. (for example: 4 readers and writers that handles 40 featureclasses each). Or do i have to make multiple workspaces?
Kind regards kees
Hi @kees_v, a possible way is to run the workspace required times through the WorkspaceRunner within the another workspace.
Since the WorkspaceRunner (Wait for Job to Complete: No) can run maximum 7 child processes concurrently, it could reduce the total time duration theoretically.
However, the processing speed depends on several factors such as RAM capacity, CPU, network performance and so on, so it's hard to exactly expect how degrees the performance could be improved actually.
Thank you very much. I will try it. Happy new year