![informix odbc informix odbc](https://dw1.s81c.com/IMWUC/MessageImages/45b8b89d53bc4c148997fb4ba988faa0.png)
To do so, install and configure an Informix client application on the ArcGIS client machine to connect to a database or geodatabase in Informix from an ArcGIS client. Also if you could supply clock time runtime in addition to the timings in the query plan output that would help.Īrt S.You can connect to IBM Informix from ArcMap or ArcGIS Server. Type table rows_prod est_rows rows_scan time est_costĬan you post one of the queries that are slower when issued to Informix along with query plans from Informix and possibly from PostgreSQL? I have some thoughts, but I want to look at the query and plans. Index Keys: serart (Serial, fragments: ALL) Lower Index Filter: root.t0.codwsa = '798763' Lower Index Filter: root.t0.codwsa = '710099' Lower Index Filter: root.t0.codwsa = '725280' Lower Index Filter: root.t0.codwsa = '702995' Lower Index Filter: root.t0.codwsa = '798780' Lower Index Filter: root.t0.codwsa = '707997' Lower Index Filter: root.t0.codwsa = '708077' Lower Index Filter: root.t0.codwsa = '708037' Lower Index Filter: root.t0.codwsa = '706195' Lower Index Filter: root.t0.codwsa = '774316' Lower Index Filter: root.t0.codwsa = '702928' Lower Index Filter: root.t0.codwsa = '460648' Index Keys: codwsa (Serial, fragments: ALL) , t12.untweb2, t12.untweb3, t0.serwsalnkįROM twsartweb t0 LEFT JOIN twsarterp t12 ON t0.serart = t12.serart , t0.serart, t12.serart, t12.typart, t12.numart, t12.serartgen , t0.flgmod, t0.flgsup, t0.codmtr, t0.datmtr, t0.datsys SELECT t0.serwsa, t0.codwsa, t0.typart, t0.sermsuart, t0.flgcre
Informix odbc driver#
Our dev team uses (symphony/doctrine) and therefore SQL generated with column aliasing and so is there a parameter in the informix ODBC driver that would allow to optimize this because the postgresql driver is not sensitive to this. We have done some tests to understand better and we find that using select with aliases (select col as col_alias) has a very big impact on performance (125%) if we do a select without aliases.
![informix odbc informix odbc](https://d117h1jjiq768j.cloudfront.net/images/default-source/products/datadirect/dci-logos/ibm-informix-logo.png)
Thanks for the answers, the FETCH_BUFFER_SIZE is already activated. Don't worry, you will get the dialog answers back in realtime, similar to 4GL, if the config is correct :-) Check the front-end configuration and if the server gets the same SQL with the same session parameters and maybe if you have a difference in cursor handling. The PHP Informix Back-End working fine, normally. Does anyone have experience to share with us regarding this dilemma because it would mean that informix in 2021 is no longer a basis for developing applications with new programming languages. We have the feeling that the bottelneck is not the engine but rather the client part which is PDO->ODBC->IFX CLIENT->SERVER.
![informix odbc informix odbc](https://community.qlik.com/legacyfs/online/194902_Screenshot_4.png)
Our problem is that the performances in comparison with PostgreSQL or Mysql are 2 times less good.
![informix odbc informix odbc](http://docs.openlinksw.com/uda/ee/eedb2win/images/EEWindb2conf02.png)
We would like to use PHP/Symphony with PDO for 100% WEB applications. We have been using Informix for 25 years with 100% satisfaction on its robustness and performance with applications developed in Informix 4gl, delphi and 4js genero.