use oci interface and in it use the array interface or use OO4O and use the array interface. Also use bind variables. Tt would make it much faster and more scalable. ODBC is going to be a dog.
--
Jim
"Charles" <u96_cwang_at_hotmail.com> wrote in message news:09mdnc96ktQVUZSiXTWJjg_at_comcast.com...
3000 rows is not a big quantity. You can load it into VC program memory, a linked list for example, and "asynchronously" load into Oracle. The connection method can be embedded SQL or ODBC.
Charles
"Nicke Verenius" <nicholaus_verenius_at_hotmail.com> wrote in message news:Fw8Ba.19250$_2.494_at_news1.bredband.com...
> Hi,
>
> I want to transfer data between a realtime-database and an Oracle database.
>
> I will use Visual C++ but how should I do to get high preformance.
>
> I must update 3000 rows in an Oracle table:
>
> TAGS - TABLE
> ------------------------
> NTAGID(PK) NUMBER:
> SNAME NUMBER
> NSMAX NUMBER
> NSMIN NUMBER
> NSCURRENT NUMBER
> NSALARM NUMBER
> UPD_DATE DATE
>
> Now, I use ODBC from my Visual C++ service:
>
> I loop through a recordset:
>
> recordset (select ntagid from tags); // about 3000 rows.
> currval = get_realtimedata(ntagid); // This comes from a realtime
> database, not Oracle
> update tags set nscurrent = currval where ntagid = recordset(ntagid);
> recordsetMoveNext;
> loop;
>
> How should I increase preformance?? Should I use ODBC??
>
> /nick
>
>
>
>
Received on Mon Jul 07 2003 - 21:55:08 CDT
