Re: RDS vs Compiled?

Douglas Wilson (dgwilson@gte.net) wrote: : I've just experienced this trying to debug compiled code. When I : used RDS it actually went faster. I also got better error messages : since the problem was an array index going out of bounds, and the : compiled version does not report that sort of error (yes, it was : bad programming that it wasn't being checked in the program, but : that's the way it was), It's been a while since I wrote any 4GL, and I don't seem to have any 4GL manuals to hand, but isn't there a -a flag that does array checking? : The compiled code might be faster in some cases, but I haven't seen : yet where its significantly faster, since the SQL is the slowest : part of the program, and is the same speed in both. I believe that RDS can be faster if you don't PREPARE your SQL statements, because it basically prepares them for you. Obviously you can eliminate this advantage by PREPARE'ing your statements yourself. June ---- June Tong Informix Software ---- ---- Senior Consultant (650) 926-6140 ---- ---- International Support junet@informix.com ---- ---- Location-du-jour: Ashford, England ---- * * Standard disclaimers apply * - Please do not send me requests/questions by mail. When I have the knowledge - and time permits, I try to answer questions on comp.databases.informix, but - travel schedule, time, and volume make responding to personal requests - difficult and often slow. Please call your local Informix Technical Support - organization for assistance with technical issues.