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 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, > > 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 > > > > --