General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
VFP does not load the entire table into memory, I'm trying to find some documentation to back this up but it's something that's well known among Fox programmers. If your tables and indexes are well designed there shouldn't be a problem. Yes there might be a delay when a form loads but if your application is well designed it should be negligible.
As I said before if you want to minimize traffic use remote views, that should send only the records you need across the network, or just send a new record depending on how you set up the view, without reading any data. Of course the table will be loaded at some level on the server side, but records will not be sent to the client.
>> Why?, opening the table should not be a problem
>
>Ooooh!
>It's a big problem in VFP. When I opening a table VFP reads all data from the table to memory for some reasons. If I have a 100,000 records (small number for normal DB) it's becomes a problem in VFP.
>
>
>> how can you write to a file without opening it?
>
>I did not tell "without opening". I told "without reading data back".
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