Re: Visual C++ and Oracle - increase speed and preformance?
From: Jim Kennedy <kennedy-down_with_spammers_at_comcast.net>
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...
"Charles" <u96_cwang_at_hotmail.com> wrote in message news:09mdnc96ktQVUZSiXTWJjg_at_comcast.com...
Received on Tue Jul 08 2003 - 04:55:08 CEST3000 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
>
>
>
>