>>Hi Jhon. I'm developing a CS system (inventory and purchases with VFE) with SQL 7 and VFP: there is a 15000 items list and the customer wants a complete combo to choose the items in the purchase order. The list uses a whole minute to show ( is a WAN connection) and they really DO want to see the entire list because the operators are mostly untrained employees. How can I optimize the time? BTW the articlles master is updated very often...
>>
>
>You might want to apply the technique I described in another message: Replicating the data from SQL -server into a VFP database. This way you ensure that every update is also updated within your local VFP table and have the performance advantage of the VFP local database engine.


Hi Walter: Could you tell me the date of the message and the thread?
TIA
>
>Walter,