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

#1

On Mon, 7 Jul 2003 15:39:51 -0400, "Charles" <u96_cwang (AT) hotmail (DOT) com>
wrote:

Quote:

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" <nicholaus_verenius (AT) hotmail (DOT) com> wrote

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

My experience is that using ODBC is quite slow, I would recommend
using the OCCI library instead.

http://www.oracle.com/technology/tec...cci/index.html

BR/Anders.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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

comp.databases.oracle comp.databases.oracle

Re: Visual C++ and Oracle - increase speed and preformance? - 11-02-2007 , 08:29 AM