Skip to Content

webi mysql reports slow

Jan 02 at 05:53 PM


avatar image

using bo 4.2 sp2, MySQL workbench 6.3, MySQL server 5.7, odbc connector 5.3. When we run a query returning 300,000 records using webi, it takes 6 minutes.

when we run the exact same query using MySQL workbench, it takes 30 seconds.

Can you suggest how we can improve performance using webi? The difference is that webi uses odbc, whereas MySQL workbench goes directly against MySQL server.

how do we get MySQL queries faster? Is jdbc faster? or any other options?

Using Oracle, 300,000 records returns in a minute, it's not a webi performance issue only that is the problem, what is going on with webi/odbc/MySQL that is the problem?

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

0 Answers