Home -> Usenet -> comp.databases.oracle -> Visual C++ and Oracle - increase speed and preformance?

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_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 Wed May 28 2003 - 21:58:32 CEST












Original text of this message