Ingres ODBC Driver slow

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
dcern
Posts: 1
Joined: Mon 14 Jan 2019 19:26

Ingres ODBC Driver slow

Post by dcern » Mon 14 Jan 2019 19:28

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!

MaximG
Devart Team
Posts: 1434
Joined: Mon 06 Jul 2015 11:34

Re: Ingres ODBC Driver slow

Post by MaximG » 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).

Post Reply