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" <nicholaus_vere nius@hotmail.co mwrote in message news:Fw8Ba.1925 0$_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_realtimedat a(ntagid); // This comes from a realtime
database, not Oracle
update tags set nscurrent = currval where ntagid = recordset(ntagi d);
recordsetMoveNe xt;
loop;

How should I increase preformance?? Should I use ODBC??

/nick



>