Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View are slow?
Message
From
01/05/2002 02:02:47
Cristian Tenea
Aquila Part Prod Com
Ploiesti, Romania
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
View are slow?
Miscellaneous
Thread ID:
00651210
Message ID:
00651210
Views:
57
Hi,

I have a 34MB table wich are updated by a local view in form.
The view prezent ~10 records from a 400000 records table. After modify 1-3 records and issue a Tableupdate() proces take ~10 to 20 seconds on a Celeron 1000 with 196MB and 100Mb network (Network is not heavy used by others).
Why view are so slow? Do not use Rushmore? (even a seek and replace will be much faster)

Thanks
Next
Reply
Map
View

Click here to load this message in the networking platform