Slow performance between CRN and MySQL DB

[SpudAggie]

Our application DB is using MYSQL on IBM Mainframe with MYSQL 3.51 ODBC connection. To filter from a 5m row single table and select 25k rows takes approximately 15 minutes. 100 rows take a second. Eliminated any join constraints on performance. Currently a single table.

Using ReportNet 1.1MR2

Has anyone else had this type of response using MySQL? If so, any suggestions or configurations we could possibly look at?

 

[the6campbells]

It may pertain to SQL constructs that by default CRN is peforming locally as opposed to sending to MySQL. You can determine this visually when you know what to look for or do it more slowly by setting the query property to database only and looking at the errors you might see re which constructs in the query will not be sent to MySQL.

I recommend you contact cognos support for more details.