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

[Charles]

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" <ni****************@hotmail.comwrote in message news:Fw****************@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