OK, i confirm the parametized queries it's MUCH MUCH more fast than normal
query (up to 3x more fast!)
Was a little "hard" to understand the api to know how to use well the
parametized queries ...
i do component for that to make it more simple to use (delphi) and call
the query like
update(SQL,
ok, i will try the parametized queries to see ...
thanks !
On 1/26/2012 11:19 PM, Leyne, Sean wrote:
>
> > > Or is this what you're already doing, just that your example was
> > > simplified?
> > >
> > > HTH,
> > > Set
> > >
> >
> > yes, of course parametized queries will be more fast, but i don'
> > Or is this what you're already doing, just that your example was
> > simplified?
> >
> > HTH,
> > Set
> >
>
> yes, of course parametized queries will be more fast, but i don't think they
> will change the ratio in the test (it's will simply be more fast for both
> variantes)
I would disagree!
> Changing the entire sql statement 10 times like your example do
> takes a considerable amount of time. The easiest way for you to speed
> things up would be to use parameters, prepare once and execute 10
> times, i.e. something like (using IBO and Pascal since that is what I
> use):
>**
>now i do in loop with one single thread, one connection :
>
>Start transaction
>insert Into Table_A(ID) VALUES('<#randomchar>'); //
>insert Into Table_A(ID) VALUES('<#randomchar>'); // (100 000 loop)
>insert Into Table_A(ID) VALUES('<#randomchar>'); //
>commit transactio
dear ann,
> Sorry for the dumb question, but why do you want to do those
> operations in parallel? The SuperServer runs only one thread at a
> time, ties a connection to an thread, and uses only one processor. Do
> you think it will be faster interweaving n commands than running the
> operations s
Stephane,
>
> I want to do simultaneous these update :
>
> Update table1 ...
> Update table2 ...
> etc...
> Update tablen ...
>
> the table1, table2, ... tableN are not connected in any way
>
> now i can do these update in parallel using n connections, but
> i would to avoid using n connection (me
Hello,
I want to do simultaneous these update :
Update table1 ...
Update table2 ...
etc...
Update tablen ...
the table1, table2, ... tableN are not connected in any way
now i can do these update in parallel using n connections, but
i would to avoid using n connection (mean start n transaction,