Re: Visual C++ and Oracle - increase speed and preformance?

From: Pete's <empete2000_at_yahoo.com>
Date: 29 May 2003 06:17:45 -0700
Message-ID: <6724a51f.0305290517.2c6c7f58_at_posting.google.com>


First, do not cross post. Second, when posting, please give details regarding what Version of Oracle you are using and platform with version. Third, you did not say what the realtime-database is, i.e., is it Oracle?

If it is Oracle, you probably would have better performance using a database link between the two instances and write a sql script to run in sqlplus using the link rather than use ODBC. Lastly, I would not recommend ODBC to do a transfer to begin with.

HTH,
Pete's

The views I may have expressed here are solely my own and not that of my employer.

"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
Received on Thu May 29 2003 - 15:17:45 CEST

Original text of this message