Hi!

1. Speed is very depended on the network hardware, number of indexes you have in tables (ther downloaded completely from the server for SELECT statements and views), size of the records, number of records. The best approach is to use application that downloads no more than 1000 records in a single record set (Search sreen is a first screen). Another approach is to maintain lookup data locally (for example, information about cities and states, some lookups in the applciation for lists in comboboxes etc.) This way you require a synchrinizing system to download these data from teh server to local machine at application startup when server data are later than local or there are no local data.

2. To learm more about VFP, just read MSDN. There are a lot of things described in the Programmer's guide. In addition, take a loot to the articles section here. Take a look to the links section here to find other sites related to VFP. Take a look to fox.wikis.com. You will find that VFP is quite popular ;)

>Greetings!
>
>I don't really know where this belongs but I figure this is a good place to start.
>
>My first questions deals with speed. My project is currently slowing down as we add records. Not good. It is most prominent on the slow machines such as the Pentium 120 out in the warehouse. I think the main problem is the number of records that's being pulled across the network. Is there a way to improve the speed? (the answer should be yes, which leads to..) How? The warehouse currently can only access the inventory section of the program which is good, however, the inventory is linked to death to other tables such as customers, invoices, order drafts, order history, arrivals, etc.. I use the Data Environment to automatically open and link all the tables but this seems to be where most of the delay comes from. The longest delay happens when opening the inventory form. The form itself has a lot of linked textboxes and a couple of grids, one of which is a simple grid to browse the whole inventory listing.
>
>Is there anything that will help manage all this data and present it without all the delay and net traffic?
>
>
>On another note, is there a good resource that I can turn to to get more background info on VFP? I've been working on this thing for 3-4 years now but only between teh months of May and August (summer holiday for me), but I still feel that I know nothing about VFP :-/