Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updateable views are too slow
Message
From
31/05/2002 19:02:19
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
31/05/2002 16:24:09
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00663659
Message ID:
00663722
Views:
18
>I have at this moment a table with 4 fields , two of them are key fields. This table contains information about questionaries identified by an internal counter. I'm using an updateable local view but it is getting too slow when the update is made taking about 10 seconds in a PII 233Mhz PC - it has about 100,000 records at this moment.
>
>Does anyone know what can be done ?

Perhaps this will get faster if you update on key fields only. See the update page of the view designer.

Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform