Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Only Views DBC
Message
From
29/07/1999 08:21:03
 
 
To
29/07/1999 03:22:19
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00247139
Message ID:
00247596
Views:
20
>Ok but I use XCASE to define all of my views and I don't think that it's possible to do that with XCASE. Is it really?

I can't tell you that, I don't use XCase.

>Is that method (Only views DBC) more faster than using DBC with views and tables when we work on a network ?

Not much. The time that it takes to get the view definition from the DBC on the network is very small compared to the actual time that the query takes, and this won't change.

I would also take into consideration that added labor of maintaining n duplicate definiions of your views- one for each workstation. It was proposed by Drew Speedie at DevCon that your framework use a programmatic DBC definition that is stored on the server, and when the workstations start the app, they grab that definition and run it, creating the dbc from scratch every time the app starts. This all sounds great in theory, but I know from experience that creating views from programmatic definitions along wit all the properties that must be set to make the view updatable takes a significant enough chunk of time to make it impractical for any of my apps to use this routine: startup would take 10 minutes.
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform