Take a look at column-wize array inserts, row-wize array inserts,
SQLBulkOperations().
"Albert" <no_spam_contactemt_at_bigfoot.com> wrote in message
news:anhdij$9p6$1_at_newsg4.svr.pol.co.uk...
> Hi,
>
> Can I implement array updating in C++ and ODBC ?
> I haven't found any examples of how to do so, can you help ?
>
> I'm doing SQLExtendedFetch() bringing back 100 rows at a time.
> I amend some fields, then update 1 row at a time.
>
> This is *very* slow (1 row 1/2 sec).
> My database will have ~250,000 rows so this is not nice!
>
> I'm working with personal oracle, so I don't need to worry abount
> contention, but a *well behaved* example would be appreciated.
>
> Many thanks.
>
>
>
>
>
Received on Fri Oct 04 2002 - 18:53:47 CDT
