Skip to Content

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

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?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

0 Answers