Re: timing of SQL calls and OWS

Hi Scott, as you can read in the manuals (Guide to SQL: Syntax), keyword "PREPARE", there is the possibility to group statements and passing them 'in a group'; simply connect the SQLs separated by ";". However I can't tell, whether performance will increase significant. I'd suggest to keep previously prepared statements and reuse them. If you get too many different SQLs, you could write your own statement-manager. In doing so, we gained impressive performance-increase. Hope this helps, Peter __________________ Mag. Peter Kolmhofer DBA Porsche Informatik (Austria) Scott Ahten wrote: > greetings all, > > i am trying to cut down on the time it takes to transmit and recieve > queries from our server. is there any advantage to passing statements > 'in a group' (one right after the other)? this might not always be > possible because the next query is depenent on the previous one, but > there are plenty of times when i generate many statements to load in a > > order. > > thanks, > > ~Scott > > -- > ________________________________________ > Scott Ahten > Code Wrangler > Silent ) Planet > scott@stage22.com > http://www.stage22.com