Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Add records/ Insert, Remote View
Message
 
À
17/07/1998 00:21:21
Brian Lee
World Access Network, Inc.
Vancouver, Washington, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00118455
Message ID:
00118509
Vues:
15
Hi Brian,

How many records are you updating at a time? Are you using Table Buffering? Do you have Key and Modified Fields for sending the updates?

>My c/s application based on Remote Views is beginning to take shape nicely after I tweaked the server Indexes in ISQL... discarding those created by VFP Upsizing Wizard, as the index key strings didn't upsize correctly.
>
>Question here, is that I am still having some difficulty adding new records through APPEND BLANK to the Remote View. TABLEUPDATE(.T.) returns .T., so the Insert is successful however, it's very slow. Seems to be table scanning, however that would seem unlikely since the server indexes are rebuilt. Simple primary key, nothing fancy. ALso, this particular table is small, 30k rows, while another table of 500k rows handles the Inserts just fine. (Separate Views for each table). What am I missing? Any help greatly appreciated.
>
>Brian Lee
>World Access Network, Inc.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform