Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!logbridge.uoregon.edu!newshub.sdsu.edu!elnk-pas-nf2!elnk-pas-nf1!newsfeed.earthlink.net!border3.nntp.aus1.giganews.com!intern1.nntp.aus1.giganews.com!nntp.giganews.com!nntp.comcast.com!news.comcast.com.POSTED!not-for-mail NNTP-Posting-Date: Mon, 07 Jul 2003 14:39:52 -0500 Reply-To: "Charles" From: "Charles" Newsgroups: comp.database.oracle,comp.databases.oracle,comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools References: Subject: Re: Visual C++ and Oracle - increase speed and preformance? Date: Mon, 7 Jul 2003 15:39:51 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_002D_01C3449E.012C5530" X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Message-ID: <09mdnc96ktQVUZSiXTWJjg@comcast.com> Lines: 119 NNTP-Posting-Host: 68.39.32.125 X-Trace: sv3-cjTcSXxxa6rYoK1v8vQmPIT+ELrQEXMIODdYlHUe6BbpRqDJGo/Wx5ucRX7gKL3DEIKFGn4HZA0oufI!xF4tw0K1tCMcxEVeM+madTqMDYW0XU5Q4UF+h/BfwZJzy+DyYYvvXLAapdgm X-Complaints-To: abuse@comcast.net X-DMCA-Complaints-To: dmca@comcast.net X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly X-Postfilter: 1.1 Xref: newssvr20.news.prodigy.com comp.databases.oracle:22922 comp.databases.oracle.misc:129106 comp.databases.oracle.server:237085 comp.databases.oracle.tools:82022 ------=_NextPart_000_002D_01C3449E.012C5530 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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" wrote in message = news:Fw8Ba.19250$_2.494@news1.bredband.com... > Hi, >=20 > I want to transfer data between a realtime-database and an Oracle = database. >=20 > I will use Visual C++ but how should I do to get high preformance. >=20 > I must update 3000 rows in an Oracle table: >=20 > TAGS - TABLE > ------------------------ > NTAGID(PK) NUMBER: > SNAME NUMBER > NSMAX NUMBER > NSMIN NUMBER > NSCURRENT NUMBER > NSALARM NUMBER > UPD_DATE DATE >=20 > Now, I use ODBC from my Visual C++ service: >=20 > I loop through a recordset: >=20 > recordset (select ntagid from tags); // about 3000 rows. > currval =3D get_realtimedata(ntagid); // This comes from a = realtime > database, not Oracle > update tags set nscurrent =3D currval where ntagid =3D = recordset(ntagid); > recordsetMoveNext; > loop; >=20 > How should I increase preformance?? Should I use ODBC?? >=20 > /nick >=20 >=20 >=20 > ------=_NextPart_000_002D_01C3449E.012C5530 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
3000 rows is not a big quantity. You = can load it=20 into VC program memory, a linked list for example, and=20 "asynchronously" load into Oracle. The connection = method can be=20 embedded SQL or ODBC.
 
Charles
 
"Nicke Verenius" <nicholaus_verenius@hotmail.com>=20 wrote in message news:Fw8Ba.19250$_2.494@news1.bredband.com...
> Hi,
> =
> I want=20 to transfer data between a realtime-database and an Oracle = database.
>=20
> I will use Visual C++ but how should I do to get high=20 preformance.
>
> I must update 3000 rows in an Oracle=20 table:
>
> TAGS - TABLE
> = ------------------------
>=20 NTAGID(PK)  NUMBER:
>=20 SNAME           = NUMBER
>=20 NSMAX           = NUMBER
>=20 NSMIN           =20 NUMBER
> NSCURRENT  NUMBER
>=20 NSALARM      NUMBER
>=20 UPD_DATE     DATE
>
> Now, I use ODBC = from my=20 Visual C++ service:
>
> I  loop through a = recordset:
>=20
> recordset (select ntagid from tags); // about 3000 = rows.
>=20     currval =3D get_realtimedata(ntagid); // This comes = from a=20 realtime
> database, not Oracle
>     update = tags set=20 nscurrent =3D currval where ntagid =3D recordset(ntagid);
> =   =20 recordsetMoveNext;
> loop;
>
> How should I increase=20 preformance?? Should I use ODBC??
>
> /nick
> =
>=20
>
> ------=_NextPart_000_002D_01C3449E.012C5530--