Fetch Records

[jamjam]

Hello,
I was wondering if anyone can help me speed up the fetching of records.

ex.
When I execute a select statement and get the first few rows of the given selection and then press the button to 'fetch last page' it seems to be "fetching" about a 100 records per time.
Is there anyway to fetch more per time.

I am using this version:
PL/SQL Developer
Version 7.1.4.1390

Thanks for any help

 

[Marco Kalter]

The buffer size is indeed 100 records per client/server round trip. There is currently no way to increase this buffer size. I would not expect big performance changes beyond 100 records per roundtrip though, unless you are fetching very small records on a very slow network.