Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Q:View/Table as a cursorsource? - part 2
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Q:View/Table as a cursorsource? - part 2
Miscellaneous
Thread ID:
00247260
Message ID:
00247260
Views:
53
Hi folks,

After new tests I realized that I can remarkably reduce the time tableupdate() takes, if I create an index into the same field of underlaying table what has been defined as a key field in the view. Even though there's is still a small delay in data processing, it's only a fraction comparing to the earlier situation.

So, saving seems to be allright now, but how to improve the fetching time of data? Indexes don't help here, do they?

Regards,
Ilkka
Ilkka Koskinen
Tel : +358 40 729 3530
Fax : +358 9 3920 7210
Email: Ilkka.Koskinen@tietoenator.com
Reply
Map
View

Click here to load this message in the networking platform