Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!in.100proofnews.com!in.100proofnews.com!cycny01.gnilink.net!cyclone1.gnilink.net!wn14feed!wn13feed!wn12feed!worldnet.att.net!204.127.198.203!attbi_feed3!attbi_feed4!attbi.com!rwcrnsc51.ops.asp.att.net.POSTED!not-for-mail Reply-To: "Jim Kennedy" From: "Jim Kennedy" Newsgroups: comp.database.oracle,comp.databases.oracle,comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools References: <09mdnc96ktQVUZSiXTWJjg@comcast.com> Subject: Re: Visual C++ and Oracle - increase speed and preformance? Lines: 148 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_015C_01C344C1.77FC34A0" X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Message-ID: NNTP-Posting-Host: 12.224.116.189 X-Complaints-To: abuse@comcast.net X-Trace: rwcrnsc51.ops.asp.att.net 1057632908 12.224.116.189 (Tue, 08 Jul 2003 02:55:08 GMT) NNTP-Posting-Date: Tue, 08 Jul 2003 02:55:08 GMT Organization: Comcast Online Date: Tue, 08 Jul 2003 02:55:08 GMT Xref: newssvr20.news.prodigy.com comp.databases.oracle:22925 comp.databases.oracle.misc:129120 comp.databases.oracle.server:237110 comp.databases.oracle.tools:82027 ------=_NextPart_000_015C_01C344C1.77FC34A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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. --=20 Jim "Charles" wrote in message = news:09mdnc96ktQVUZSiXTWJjg@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" 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_015C_01C344C1.77FC34A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
use oci interface and in it use the array interface = or use=20 OO4O and use the array interface.  Also use bind variables. Tt = would make=20 it much faster and more scalable. ODBC is going to be a = dog.

--
Jim
"Charles" <u96_cwang@hotmail.com> = wrote in=20 message news:09mdnc96ktQVUZSiXTW= Jjg@comcast.com...
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=20 be 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=20 want to transfer data between a realtime-database and an Oracle=20 database.
>
> I will use Visual C++ but how should I do = to get=20 high preformance.
>
> I must update 3000 rows in an = Oracle=20 table:
>
> TAGS - TABLE
> = ------------------------
>=20 NTAGID(PK)  NUMBER:
>=20 SNAME          =20 NUMBER
>=20 NSMAX          =20 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=20 set 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_015C_01C344C1.77FC34A0--