Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updateable views are too slow
Message
From
02/06/2002 18:33:07
Charlie Schreiner
Myers and Stauffer Consulting
Topeka, Kansas, United States
 
 
To
02/06/2002 11:59:44
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00663659
Message ID:
00663917
Views:
25
Hi Carlos,
The Update will be WHERE KeyField1=?Something AND KeyField2=?SomethingElse--so you need two indices that match the two expressions above exactly. (Not the above expressions, but your expressions--you know what I mean.)
>The table to be update has an index based on the keys for the update, both of them character and without any filtering. I think they can be optimized although I haven't checked for it yet.
>
>Thank you.
Charlie
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform