Hi!
You can use Fetch As Needed option with remote views. However, it depends on the data source. It works with SQL Server, for example, and does not works with VFP ODBC (as far as I know).
Also, try to limit number of records users get in resulting view. For example, my form in such case consists of 2 pages, first page is search criteria plus grid, second page is a form with fields to edit records. Navigation through records and editing only from that data set that is get by search criteria. No more than 1000 records displayed, so used must narrow down the search criteria to get less required records. I could hardly magine somebody is able to process more than 1000 records in a hour. For a next hour - get ecords by another search criteria :)
HTH.
>HI,
>
>Im using remote views to gather data from my base tables. The problem is if there are more than 3 users accessing the same form that queries all customer records from the base table, the system processing is too slow. The form is not being displayed until all the records were in the remote view.
>
>Is there a way wherein I may display the form while querying for other records?
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.