Re: Visual C++ and Oracle - increase speed and preformance?
Date: Fri, 02 Nov 2007 20:29:52 +0800
On Mon, 7 Jul 2003 15:39:51 -0400, "Charles" <u96_cwang_at_hotmail.com> wrote:
>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.
>"Nicke Verenius" <nicholaus_verenius_at_hotmail.com> wrote in message news:Fw8Ba.19250$_2.494_at_news1.bredband.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);
>> How should I increase preformance?? Should I use ODBC??
My experience is that using ODBC is quite slow, I would recommend using the OCCI library instead.
BR/Anders. Received on Fri Nov 02 2007 - 13:29:52 CET