The app server is slow when running XOG, what can be done to make sure the performance is optimal, any best practices?
Running multiple threads for XOG at once could be memory-consuming. We recommend:
Adjusting your usage to avoid running many XOGs at the same time
If possible avoid separate connections (have XOG connect once and reuse the session)
Do not request many thousand of rows at once, each request should be small, and each small request should be paginated. Otherwise, there is the possibility for a large request to time out and spin another request, which also times out, etc.
Another option to improve your bandwidth could be to have a dedicated app server for XOG only.