Re: Splitting string on blanks in 4GL?

> perryd@fourgen.com (Perry Dillard) writes: > }>>>>>>>>> Perry's response to Nils.Myklebust@CCMAIL.telemax.no <<<<<<<<<< > > I must warn you that the Informix substring manipulation is > _exteremely_ expensive in the compiled version. I'd think > about writing a routine in C to split your data. A good point, but we use it a lot without any performance problems. Even things that are "expensive" is often masked completely by database access. Most of the time we find 4GL programs easier to write than C code. Also we want as little C code as possible to avoide problems should we decide to use RDS. For future compiler technologies from Informix we do however see it as important that they optimise better so these problems disappear. I you look at the C-code generated it can't be fast doing anything. An example of something that is too expensive is if you use a lot of sum/group sum in a report. You may see runtimes where these calculations take most of the time to finish the program. Nils.Myklebust@ccmail.telemax.no NM-data, Dalsbergstien 7, N-0170 Oslo, Norway My opinions are those of my company