Re: ADO .NET and Informix

Is the current version of the SDK from IBM still 2.90? I'm using that,
and I have a complicated query that takes > 10 minutes to run using
this driver. I will also try the generic ODBC driver.




Amit Dandekar wrote:
I have observed that Informix .NET provider gives
better performance than that achievable by using
ODBC-NET bridge.

Also , AFAIK , the NET provider does not use OLE-DB
under wraps.

As Zackary said , a lot of problems with the .NET
provider have been getting cleared up with the latest
releases and hopefully the trend should continue.



--- zackary.evans@xxxxxxxxx wrote:

We are considering doing the same thing. Just
beginning design and
coding.

I would suggest using the generic .NET ODBC classes
(we are using the
ver 2.90 odbc driver) instead of using the .Net
wrapper provided by the
Informix CSDK. Apparently it uses OLEDB which causes
many performance
issues because of COM interop overhead (alot of
"unmanaged" code).

Also, I suggest you perform a major stress test
early in the
development stage of your project. There were some
memory leak
problems with the informix ado drivers in the past,
they seem to be
cleared up but its much better to find it now then
once you get into a
production environment. Basically you want to run a
couple million
queries against the informix box through the odbc
driver, then make
sure the db mem didnt grow massively and then blow
up or slow to a
crawl.

GL

Tam OShanter wrote:
Hello Friends,

We are scoping out a project to replace a
component of an old school, legacy
application written in ESQL with a .NET service
based application.
To this end, wondering if anyone here has had any
experience with using .NET
and Informix together.

All anecdotes are welcome.
Specifically, wondering if anyone knows of any
caveats in using ADO that
would potentially save me time, and/or, cause me
to look in a different
direction.

As always, thanks for you time in reading and
replying.

Cheers,

Tam.

_______________________________________________
Informix-list mailing list
Informix-list@xxxxxxxx
http://www.iiug.org/mailman/listinfo/informix-list


.

Relevant Pages

  • Re: ODBC Driver Problems
    ... Refer to http://www.synametrics.com/SynametricsWebApp/WinFAQ.jsp and scroll down to the section for Informix. ... ODBC Driver to work. ... The displayed locale and codeset have not been found on the client ...
    (comp.databases.informix)
  • ODBC Driver Problems
    ... I have just changed PC's and am having difficulty getting my Informix ... ODBC Driver to work. ... The displayed locale and codeset have not been found on the client ...
    (comp.databases.informix)
  • Re: ADO .NET and Informix
    ... I would suggest using the generic .NET ODBC classes (we are using the ... ver 2.90 odbc driver) instead of using the .Net wrapper provided by the ... Informix CSDK. ... problems with the informix ado drivers in the past, ...
    (comp.databases.informix)
  • Re: ODBC driver
    ... You're looking for Informix Connect or Informix SDK for your platform. ... you may want to stick to release 2.81 unless you are already running IDS 10.00 exclusively - 2.90 assumes the engine allows ORDER BY columns that were not selected and sends such queries through where they fail. ... query was submitted that included an ORDER BY a non-selected column, the driver would modify the query to include the extra ORDER BY column so the query would not fail on older server versions and then just discard the extra data. ...
    (comp.databases.informix)
  • RE: infromix license question
    ... I mean, when you buy an IDS its includes free informix connect product, ... to client this is the product that you need. ... Subject: Re: infromix license question ... I don't understand your words "ODBC driver is not charged ". ...
    (comp.databases.informix)