Paging Mode (as BDE TTable)

[b_yaghobi]

Please add pagging fanctionality in your SDAC product.
(as BDE TTable )

[Jackson]

Please describe more detailed the functionality you want us to add.
Specify in what cases your are going to use it.

[b_yaghobi]

How can we use SDAC in Pagging mode ?

1) FetchAll = False
2) FetchRow = 25

3) DataSet.Last

we want SDAC come only 25 last record.

( TTable in Delphi strongly support it )

Is SDAC support it ?

How can we use SDAC in Pagging mode ?

1) FetchAll = False
2) FetchRow = 25

3) DataSet.Last

we want SDAC come only 25 last record.

( TTable in Delphi strongly support it )


http://www.crlab.com/forums/viewtopic.p ... 5e5feeb159

[Jackson]

Try to use TCustomDADataSet.UniDirectional property.
If it isn't acceptable for your task, please describe the situation
when you need to fetch a greate number of records to client side with navigation support.

[b_yaghobi]

Hi,

in BDE you can go to last record in table without TTable fill with all records !
only 1 last page of data in table.

if you can add this functionality (manage your buffer only with records that need)
by meens SDAC buffer must be cache only records that need 25 or 30 or...
and free another records.

[Jackson]

We are investigating the opportunity to add this functionality,
but due to low number of users' requests it is unlikely that we will add it in the nearest time.

[b_yaghobi]

This problem made with meny of records ( > 100,000 ) then if you want
go to last record in DBGrid this opration have very very low.

Thank you for add this functionality in your SDAC product.

Babak Yaghoobi

[RandySill]

I tried implementing this with Keyset and Static cursors, but performance was even slower. I have a customers grid with >700,000 rows and user can just start typing name and it jumps to nearest record matching typed name. SDAC is fastest to open the many row dataset, but too much data over the network. Would be great if only the required data be pulled that is needed to show in grid. It's possible to do this by hand, but I will have to write a custom component to make it feel the same and keep track of tagged records. This is very similar to paging records.

Randy

[b_yaghobi]

Hi CoreLab Team

Can you add this functionality in SDAC ?

Thank you

[Antaeus]

Implementing such mode will take pretty much time and changes in SDAC. But this mode does not seem to be a called-for option. So it is unlikely that we will add it in the near future.
If neither of previous suggestions suits your needs, you can try to implement the paging mode in your applications by adding some extra conditions to your queries to restrict count of returned records.