Visual C++ and Oracle - increase speed and preformance?

[Quoted] [Quoted] I want to transfer data between a realtime-database and an Oracle database.

[Quoted] 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

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;

[Quoted] How should I increase preformance?? Should I use ODBC??

/nick Received on Wed May 28 2003 - 21:58:32 CEST