On 13/11/2010 06:25, ozjazzfan wrote:

> If I'm writing an app that only generates SQL that has up to a known max
> number of params (say up to 10 in and 60 out), why can't I just allocate
> the max at the beginning of the app and re-use the structures over the
> lifetime of the app?
>
> Set the sqld and sqln members to the number of params actually used,
> assign the sqlvar array and away you go...

not a C++ guru here, so... ;)
anyway, as a first step, I'd say that you must serialize and synchronize
requests (i.e. no multithreading and no asynch).
You don't specify dev. sys. and O.S. so I've not many other things to say.

Ciao.
Mimmo.