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)

Thank you.