Re: Dynamic SQL vs. ESQL/C

Posted in 1996

Alexander J. Oss — Thu, 18 Jul 1996 09:24:06 -0300 — source: Informix-list mailing list archive (1991-1998)

Joan Armstrong wrote: > Does anyone have *real data* on the performance of dynamic sql (called > from C) vs. ESQL/C? Unfortunately, I don't have real data since my OnLine 7.10.UC2 has decided to give me segmentation faults, but what you may wish to do is compare the C code generated by ESQL/C in both cases; my guess is they are very much the same (that is, EXEC SQL statements get translated into dynamic SQL C code). But please, if someone knows for sure, correct me. I'm just going on cursory inspection of the generated C code. -- Alexander J. Oss Computer Systems Manager Films for the Humanities & Sciences