Skip to Content

How to speed up getting a large amount of sql queries?

Jul 18, 2017 at 02:21 PM


avatar image
Former Member

Our task is to retrieve sql queries of all reports we have. Now we are using Restful Api for this, we send approximately 26k of requests for each dataprovider and it takes quite a lot of time. Is there any suggestions to speed it up?
1. Is there any difference in speed between json and xml as accept type?
2. Is there any sence in using multithreading? Does server have the limit of simultaneous answers?
3. Do we have to change some server settings?
4. Maybe it is better to use Java SDK? I know that earlier it was possible to retrive dataprovider's query using the class rebean.wi, but we use BusinessObjects BI Platform 4.2 Support Pack 3 Patch 2 and according to since 4.0 rebean.wi doesn't implement this function any more. What are the other ways to get sql query?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers