Page 1 of 1
Ingres ODBC Driver slow
Posted: Mon 14 Jan 2019 19:28
I have the problem that SQL-Queries are very slow with an Ingres database and Ingres ODBC driver (version 2.8).
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
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).