Michele,
Yes, your app needs to undergo a major mindset change. In the client server world you are interested in getting the smallest possible datasets back from the server.
Rather than having someone scroll through 350.000 records to find the one or few they are interested in.. think of giving them a GUI that allows them to specify what they are really interested in, things like names or partial names, dates or date ranges. They populate the gui with the items and click a button which lets you fetch the relevent data and allow them to browse that dataset to get to the row they really are interested in.
>We have a great application written in VFp9 with data stored in Vfp Tables. We need to upsize the application and pass to SQL server. In the tests we have done i have seen that some operations now i do with fox tables are not possible with SQL or better probably i don't know how to do them. An example: i have a table with 350.000 records and when i manage this table i display a grdi where the user navigate or look for a particular record. Now if i use a remote view the structure is similar but if i choice a "Go Bottom" feature or a locate to a record near the bottom i have to wait too much time to have the results. For this problem what can i do ? I have to abandon a similar structure or i can reach this. Someone can suggest me the better solution to this problem?
>Another question is about finding documentation about the better solution to access remote data (remote views, ADO, cursoradapter object) ?