Re: ISQL -> Online performance improvments

Posted in 1991

David Snyder — Mon, 1 Apr 91 11:20:25 EST — source: Informix-list mailing list archive (1991-1998)

John Lengeling, in your mail you wrote: > > I have a client who has a large Informix database written in ISQL > 2.10.00. Some of the processing written SQL takes 2 hours to run on a > 120,000 row table with appropriate indexes. Would upgrading to Online > engine provide a drammatic improvment in performance or would recoding > the SQL into 4GL be better. As a rule of thumb how much performance > inprovment can be achieved by moving from ISQL or SE to Online? > What about ISQL to 4GL? > That all depends on what type of processing is being done. Machine intense processing will be improved by ISQL -> I4GL Database intense processing will be improved by SE -> ONLINE Me, I'm a power monger and I'd do both... DAS -- David A. Snyder @ UE&C - Catalytic in Philadelphia, PA UUCP: ..!uunet!trac2000!das INTERNET: das@trac2000.ueci.com