Re: Stored procedures and esql/c

I don't have any good ideas for you other than to say this is one of so many reasons one need the Informix Universal Server for fairly regular databases (without fancy new datatypes). In the Universal Server you could have solved this type of problem very elegantly via C or Java code in the database. "Peter Jones" <pete@pkjones0.demon.co.uk> wrote: :I have been asked to write an application in ESQL/C which is called :from a stored procedure. I am experiencing performance problems :because the program has to connect to the database each time it's :called as well as perform a load of PREPARE's, etc. : :I've experimented a little with an intermediate process which manages :signaling to a second (main) process. This has turned out to rather :cumbersome as it has to deal with simultaneous calls. The program :also accepts parameters from the stored procedure, and the stored :procedure in turn must wait for the C program to complete. : :Any ideas ? : :[ HPUX 10 + Informix 7.2 ] Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org