Re: Visual C++ and Oracle - increase speed and preformance?
From: Jim Kennedy <kennedy-down>
Date: Tue, 08 Jul 2003 02:55:08 GMT
Message-ID: <goqOa.2299$sY2.2021_at_rwcrnsc51.ops.asp.att.net>
Date: Tue, 08 Jul 2003 02:55:08 GMT
Message-ID: <goqOa.2299$sY2.2021_at_rwcrnsc51.ops.asp.att.net>
use oci interface and in it use the array interface or use OO4O and use the array interface. Also use bind variables. Tt would make it much faster and more scalable. ODBC is going to be a dog.
-- Jim "Charles" <u96 cwang_at_hotmail.com> wrote in message news: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...Received on Tue Jul 08 2003 - 04:55:08 CEST
> 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
>
>
>
>
--