Data source independent connections in coming in RC5.3

[HankFay]

Yes, the problem is exactly that.. :-)
In my old application I've used the view as a Datasource in some form.. but with more records, the performance in a lan application are not good..

As David said, you use parameters (which Barry helpfully showed how to change on-the-fly). Under VFP the view would be opened with the NODATA command (use myview nodata), and then requeried. Until Barry adds NODATA to the USE command, it's easy enough to put the code Barry used into a little prg like pspOpenVT(<cview>,<calias>,<lNoData>,...) (our library routines begin with "psp" so they are easy to keep straight). Then you provide a place of the user to query which records they want.

If you want to show them all 2M records, Herb's idea (below), which VFP uses (except I think the default is 100 records), can work. But you will still need to give the user a way to select from that many records, so what's gained by showing them the first 50 records they probably don't want (of the 2M)?

Hank

[barrymavin]

Herb, the problem with that approach is the full query is still performed on the server. There is a fetchsize in the CA. I need to enable it in the properties of the VT.

One of the shortcomings of MSSQL is the lack of a limit clause on sql select. Most other databases (e.g MySQL, LIanjaSQL) have this. MSSQL TOP(n) is not a substitute when paging through large amounts of data.

I will revisit deferred fetches later, only drawback with it (having looked at it) it requires a permanent connection to the server resultset which can be resource intensive on a heavily loaded system.