General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Foxpro will open the base table at the same time as the view and leave it open, to speed up requery(), I think. You can see this by designing a local view, open it and then open the Data Session window. And no, the base table data isn't tranferred to the client machine to issue the update, only the data from updated records.
>Hi all,
>
>I have a question regarding VFP's performance across a local area network as to how it handles data transfer between the client and server computers.
>
>In our case, we have a 501 MB (2,000,000+ rows) table sitting on a server. Our application does not open the table directly but uses a local parameterized view to extract data.
>
>My question is: When our application issues a tableupdate() in optimistic row-buffering mode, I know VFP opens the base table and the corresponding CDX file, does VFP 'gets' the base table data with the index to the client machine to issue the update? Is the entire base table with CDX 'transferred' across the network?
>
>Any feedbacks, comments or links highly appreciated.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only