Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Speed of Views Vs Tables
Message
From
30/10/2003 09:33:41
 
 
To
30/10/2003 08:52:01
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00844370
Message ID:
00844487
Views:
23
Hi,
Sorry for jumping in.
I have experienced diffuculty of using local view to update records in my item promotion maintenance. This maintenance allows user to key in any items that offered discount within a given period.

The number of items in any promotion would usually exceed 200. VFP takes 10-15 seconds to save it to table. My clients always complaint about it. At the end, I got to use underlying table instead of local view. And VFP only takes 2 seconds to save it.

Do you have any workaround?

Thank you
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform