General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>What bothers me with all the scenario you described is that you are retriveing alot of records for this view - this should have a performance hit for the whole creating process as well
>you may want to re-design this to bring and update data in smaller chunks alltogether - of course I don't know enough on your program so what you are doing might be the most sensible way to go
This would be ideal, but it's not possible. Some of the data in the dbf comes from the remote view and I need to search the remote view for it. Almost obvious, I cannot search it if I don't retrieve all the data first.
But probably I could close the remote view when I have all the data in the new dbf and do the update on a different view based on the same table, but in smaller chunks as you suggest. Thanks. I will try this.
>I just gave a VFP course in our company to new programmers and in one lesson I covered the different ways to access remote data from VFP (Remote views vs. SQL Passthroughs VS. ADO) if it is interesting to people I can probably publish it on VFUG and/or here
Of course it would be interesting. I am interested anyway. Thanks a lot. Let me know when it will be available.
Vlad
Previous
Next
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