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

From: Nicke Verenius <nicholaus_verenius_at_hotmail.com>
Date: Wed, 28 May 2003 21:58:32 +0200
Message-ID: <Fw8Ba.19250$_2.494@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 Wed May 28 2003 - 14:58:32 CDT