Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
File/Server vs Client/Server
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00010711
Message ID:
00010719
Views:
29
>>Could some one please explain why it is better to use VFP as a front end to a database like Oracle etc using remove views and ODBC etc as opposed to just using VFP databases/tables. Also if you have a VFP table on the server, what are the performance problems with accessing it the old fashion USE table way and then doing select sql's as opposed to setting up views. I'm wondering if it is worth the effort to convert my whole app to this type of data sharing.
>>
>>TIA
>
>Today is your lucky day! (s) Check out the October Newsletter in VFUG, there's an article about VFP C/S development there.
>
>Scot.
Read the article and it is very helpful but I still have some specific questions. When you issue the command

Use mytable

How much network traffic does that generate? If then you create a cursor from the table for use in the forms, is the whole table sent across the network and then the sql executed locally, or does the server execute the sql and just send back the cursor. (talking just in VFP not with MS SQL server).

Second question. I have a grid which displays data from a large table, 10,000 records and thus 10,000 rows. Movement is fast because I use a text box to enter seeks (like the jkey browse). Would changing this to an SQL remote view decrease the amount of network traffic? It strikes me as that data still needs to get sent to the local machine.

My apps will typically have 10-50 users accessing single records from some tables but also acessing whole tables as well. Since MS SQL is not cheap, especially if you have to install it at each server, I am trying to get an idea on how cost effective for the end user making this switch will be.

Right now the slowest part of the app is loading complex forms into memory which I understand VFP 5.0 will improve.

TIA
Todd Burstain, MD
infinitydoc@delphi.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform