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

I have recentely run some timing tests on several of our platforms. The best rate for processing that I have been able to get is about 1200 inserts per second (3.9 million per hour) (no data reads, rows are a sequence.nextval, sysdate and to_char(sysdate)and are for testing purposes only). This was on a non-dedicated multi-tasking platform with production and development going on, so a dedicated platform might do better.

As for speeding up the process, if you use fixed length rows (so you can calculate and know the number of rows per block) and a tuned SGA, then if you access the rows by rowid instead of key value??????????

In article <01bd8215$218a2e70$7198fac3_at_paranoid>,   "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
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon May 18 1998 - 00:00:00 CDT