Ingres ODBC Driver slow

[dcern]

Hello community,

I have the problem that SQL-Queries are very slow with an Ingres database and Ingres ODBC driver (version 2.8).

For example:

 $average_runtime = Yii::$app->db->createCommand("select top 5 a, avg(freed-b) as 
            c from xxxx where d> '2018-10-10' group by a order by a")

needs round about 5 seconds for 5 listings. Can anyone help me to improve this? Are there any tips?

Thanks in advance!