Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
- Posts: 1
- Joined: Mon 14 Jan 2019 19:26
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!
- Devart Team
- Posts: 1434
- Joined: Mon 06 Jul 2015 11:34
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).