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

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 - 08:17:45 CDT