>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 :-/
Jonathan,
You might start adding these to your config.fpw (assuming c:\temp exists) :
editwork=c:\temp
progwork=c:\temp
sortwork=c:\temp
Instead of these 3 lines you might use :
tmpfiles=c:\temp
but above is compatible with older versions too. This at least reduces the network traffic for temp files fox creates.
Cetin