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

"alex" <alexvak_at_hotmail.com> 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
>

Its not clear what you mean by 'testing' the data 100 times a day....please explain further, and in the meantime, read up on trigger usage and validity checking in the Oracle manuals...Particularly the Server Concepts and Administrator's guides...

John Greco
Oracle DBA Received on Mon May 18 1998 - 00:00:00 CDT