Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Views
Message
From
16/03/2001 17:48:06
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Views
Miscellaneous
Thread ID:
00486147
Message ID:
00486154
Views:
13
>Can someone tell me on a general level is it bad to use updatable local views on large record sets (say 50,000) records. In my database which has stored procedures as well as referential integrity it seems to take forever to send the updates back to the table. Any ideas??

Views are generally a good idea for general application architecture, but can show their weakness when used on huge data sets. In operations on very large data sets where speed is a concern, you would probably be better served operating on the tables directly.
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform