Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updateable views are too slow
Message
From
31/05/2002 21:13:36
Charlie Schreiner
Myers and Stauffer Consulting
Topeka, Kansas, United States
 
 
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:
00663749
Views:
24
Hi Carlos,
What indexes are on the source table of the view? Do they allow the update to be rushmorizable?


>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 ?
Charlie
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform