Re: How can I take 10000 rows from oracle in 1 second?

Have you tried pining the Oracle tables in memory ? If you have enough memory, you can store the tables in memory permamently. I've never done this but it should help performance greatly. The Pro*C solution generally tends to be MUCH faster than regular SQL.

Cliff

alex wrote:

> In Oracle I have 1gb of data and I have to test it all every day 100 times.
> I wrote small program in C using mfc classes and it took me 10 seconds to
> get 7000 rows from Oracle, but it is so slow, is there any way I can
> "speed" the process up?
> Is there any way to have dirict access to oracle tables? Or Is it possible
> call oracle say put 100000 rows in the varibles?
>
> Any idea would be greate help
>
> Thank you
>
> Alex
> Email: alexvak_at_hotmail.com

       The contents of this message express only the sender's opinion.
       This message does not necessarily reflect the policy or views of
       my employer, Merck & Co., Inc.  All responsibility for the statements
       made in this Usenet posting resides solely and completely with the
       sender.