Skip to main content
Solved

i want multiple readers to read at the same time.

  • December 16, 2019
  • 2 replies
  • 90 views

Forum|alt.badge.img

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

Best answer by takashi

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.

View original
Did this help you find an answer to your question?

2 replies

takashi
Influencer
  • Best Answer
  • December 16, 2019

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.


Forum|alt.badge.img
  • Author
  • January 3, 2020

Thank you very much. I will try it. Happy new year


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings