I know that the server is underpowered, but that is what my customers are working with by and large. I suppose I should rephrase my question to - can VFP still be used for low end vertical market applications that generally run on peer to peer networks and are used by non technical people? What are the requirements for adaquate performance on a network?
My app is not that complex - though it will have a total of almost 100 tables in it by the time of completion. The rows in the tables generally are quite small though several may eventually number 100,000 rows or more. The current dataset I am testing has no more than 25,000 records in any 1 table.
One thing that really bothers me is that I have a listbox class that changes color when it receives focus and then changes color back when it loses focus. I do this on all input boxes so the user will know where he is. When the screen comes up it sometimes takes up to 5 seconds before the listbox changes color. This is after it takes 5 seconds for the screen to come up.
A problem is a problem only as long as it has a possible solution. Lacking that, it becomes a FACT!