Skip to Content
avatar image
Former Member

webi mysql reports slow

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers