Re: ISQL vs. 4GL

Posted in 1998

Art S. Kagel — Mon, 10 Aug 1998 12:51:38 -0400 — source: Informix-list mailing list archive (1991-1998)

Kai Shen wrote: > > Hi, > is there any known performance difference between ISQL and a 4GL > program? > In our special case I want to do a major delete and insert between two > servers connected by INET. > I thought maybe a prepare cursor with 4GL could save me some time > compared to plain SQL. Prepared cursors only save time if they are reused many times. Then the overhead of optimizing the query is spent once and taken advantage of frequently thereafter. Otherwise the frontend software does not matter for pure SQL. The engine does the actual work after all so it does not matter whether CLI/JDBC/ESQL-C/ESQL-COBOL/ISQL/C4GL/R4GL the query's runtime is the same. Art S. Kagel