Re: Visual C++ and Oracle - increase speed and preformance?
From: Charles <u96_cwang_at_hotmail.com>
Date: Mon, 7 Jul 2003 15:39:51 -0400
Message-ID: <09mdnc96ktQVUZSiXTWJjg_at_comcast.com>
>
> 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 Mon Jul 07 2003 - 21:39:51 CEST
Date: Mon, 7 Jul 2003 15:39:51 -0400
Message-ID: <09mdnc96ktQVUZSiXTWJjg_at_comcast.com>
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_verenius_at_hotmail.com>
wrote in message news: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 Mon Jul 07 2003 - 21:39:51 CEST