Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Data gathering speed
Message
 
 
À
08/10/2002 04:17:53
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00708645
Message ID:
00708667
Vues:
8
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.com
ICQ #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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform