>Hi all,
>
>I know that this is a basic question, but I am self taught and just don't know the best solution. I have an application running
>at a local office for medical and dental claims processing. It is a good multi-user application, it handles the locks and the
>updates and everything else just fine. But performance wise, it really lags and I don't know what to do. The program and tables are on
>their one local server, and everyone in the office (10 people) accesses the application.
>
>My clients love my application, they just don't like the slow response times especially when they all start getting on together.
>Is there something that you could recommend to me to read so that I would know how to better design more robust applications?
>
>Thanks in advance, this thread has been a tremendous help over the past 9 months to me as I struggled to learn VFP.
To the other suggestions, I want to add:
Apart from deleting indices on "deleted()", you might also want to get rid of some other indices that return too many records: "Rushmore Optimization" basically means that if an index exists for an expression, it is used, whether this speeds things up, or contrarywise.
For tables that have a few scores of thousands of records, use views instead of tables. This is especially practical, and feasible, when the big table is a child of another table, and you only need to show records that correspond to the parent record (examples: all invoices for a client; all line details for an invoice).
For reports, instead of using a single SELECT - SQL statement that joins many tables, it is usually much faster to join two tables at a time. Example: I could reduce SELECT time for a certain report from 50 seconds, to 2 seconds. It seems that here, too, VFP Optimization is always what you want.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)