Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 6 of 6 total
Thread Number of rows returned in one block
Tue, Nov 25 2014 5:57 PMPermanent Link

jwtm

I would like to increase the number of rows returned in each data block returned from the server after a query is opened. I'm getting 2K (approx) blocks and would like to at least double the size.

Can't find anything in the reference manual but the manuals are not searchable so I could easily have missed the setting. Any ideas?
Tue, Nov 25 2014 6:33 PMPermanent Link

Raul

Team Elevate Team Elevate

On 11/25/2014 5:57 PM, jwtm wrote:
> I would like to increase the number of rows returned in each data block returned from the server after a query is opened. I'm getting 2K (approx) blocks and would like to at least double the size.
>
> Can't find anything in the reference manual but the manuals are not searchable so I could easily have missed the setting. Any ideas?

I'd suggest RemoteReadSize property  :

http://www.elevatesoft.com/manual?action=viewprop&id=edb2&product=rsdelphiwin32&version=XE7&comp=TEDBDataSet&prop=RemoteReadSize


Raul
Wed, Nov 26 2014 2:10 PMPermanent Link

jwtm

Raul wrote:

On 11/25/2014 5:57 PM, jwtm wrote:
> I would like to increase the number of rows returned in each data block returned from the server after a query is opened. I'm getting 2K (approx) blocks and would like to at least double the size.
>
> Can't find anything in the reference manual but the manuals are not searchable so I could easily have missed the setting. Any ideas?

I'd suggest RemoteReadSize property  :

http://www.elevatesoft.com/manual?action=viewprop&id=edb2&product=rsdelphiwin32&version=XE7&comp=TEDBDataSet&prop=RemoteReadSize

---
Thanks. Present in XE7 docs, not present in D2007 docs. Now I have somewhere else to search.
Wed, Nov 26 2014 2:51 PMPermanent Link

Raul

Team Elevate Team Elevate

On 11/26/2014 2:10 PM, jwtm wrote:
> Thanks. Present in XE7 docs, not present in D2007 docs. Now I have somewhere else to search.

Are you referring to online or installed docs ?

It's definitely present in online D2007 docs :
http://www.elevatesoft.com/manual?action=viewprop&id=edb2&product=rsdelphi&version=2007&comp=TEDBDataSet&prop=RemoteReadSize

Raul
Wed, Nov 26 2014 4:34 PMPermanent Link

jwtm

Raul wrote:

On 11/26/2014 2:10 PM, jwtm wrote:
> Thanks. Present in XE7 docs, not present in D2007 docs. Now I have somewhere else to search.

Are you referring to online or installed docs ?

It's definitely present in online D2007 docs :
http://www.elevatesoft.com/manual?action=viewprop&id=edb2&product=rsdelphi&version=2007&comp=TEDBDataSet&prop=RemoteReadSize

Raul

Online. I'm going blind. Bill
Wed, Nov 26 2014 10:34 PMPermanent Link

Raul

Team Elevate Team Elevate

On 11/26/2014 4:34 PM, jwtm wrote:
> Online. I'm going blind. Bill

No, same here. That setting for some reason seems invisible on the page.
I knew it had to be there (since i've used it) but otherwise i missed it
on 1st glance also when i was looking for it.

Raul
Image