Re: Visual C++ and Oracle - increase speed and preformance?
Date: Fri, 02 Nov 2007 20:29:52 +0800
Message-ID: <du5mi35338tesr8gqijhhncfajp2pp6akr_at_4ax.com>
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.
>
>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
>>
>>
>>
>>
My experience is that using ODBC is quite slow, I would recommend using the OCCI library instead.
http://www.oracle.com/technology/tech/oci/occi/index.html
BR/Anders. Received on Fri Nov 02 2007 - 13:29:52 CET