>Hello guys,
>
>I inherited a POS application that is having issues with speed. Basically there's one laptop who is the "server", it has all the data, and the other laptops are the "checkouts" which connect to the server via a wireless network and access the data, just the server and usually 1-3 checkouts. Of course one problem is that foxpro is bringing all the data over the wireless network and as more checkout laptops are added to the network it begins to crawl (even though the tables are not that big), actually adding just one checkout it crawls. The code is a combination of everything since a few programmers have had their crack at it.
>
>It would be nice to rewrite the app but that's not in the cards right now, just coding for new requirements, so my question would be what suggestions you guys have to try to make the checkouts faster? (code strategies/hardware changes/etc)

Running a file/server VFP app across a wireless network is, IMO, worse than a bad idea, it's bad practice. Your best bet will be to buy a small gigabit switch ( 8-port is probably big enough ) and run some Cat5e cable to each location. That, by itself, should be enough to make your speed issues go away.

Also ensure that antivirus on both the "server" and all "checkout" computers is not real-time scanning the VFP data tables and VFP temp file folders on all computers.