Page 1 of 1

Ingres ODBC Driver slow

Posted: Mon 14 Jan 2019 19:28
by 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:

Code: Select all

$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!

Re: Ingres ODBC Driver slow

Posted: Tue 15 Jan 2019 08:57
by MaximG
Our ODBC solutions product range does not include a driver for working with Ingres database. Please specify the Devart product you use with which you use the mentioned ODBC driver (version 2.8).