Hi to all,
I've to display a big remote view, I know that with FetchSize or MaxRecords I can say to fetch N records each time, but I haven't use it before now so my question is:
Which difference between MaxRecord and FetchSize ?
How does the FetchSize option work ? The SELECT on the server is completed before to retrieve my first N records or what ? If I set the view as RecordSource of a grid the new record will be loaded when I scroll down by itself or I have to do a requery o sqlmoreresult or other ?
Which is the best way to display totally a big view in a grid ?
thanks in advance