Re: updating multiple rows with ODBC

In addition, make sure that you don't have autocommit on (unless you actually need to commit after every row). This is the default behavior for ODBC and will really cause the application to drag.

You may also investigate creating a stored procedure that does the actual update when you pass in arrays of values. You could take advantage of the bulk insert syntax that way.

Justin Cave
Distributed Database Consulting

"Ken North" <KenNorth_at_nospam.msn.com> wrote in message news:<ann84a$nml$1_at_nntp-m01.news.aol.com>...
> 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 Mon Oct 07 2002 - 20:31:24 CDT