VFP performance in LAN environment

Visual FoxPro is one the fastest performing desktop and LAN-based database management system available today. But opening large tables creates a great deal of network traffic. This can be a substantial delay, sometimes beyond an acceptable length of time. In this article I present the results of the VFP speed measurement in the process of acquiring database data with different VFP9 methods. The store procedures, duplicated records and unique indexes enriched by the programmers’ knowledge of the database organization can speed up the data query. With the stored procedure we can fetches the result set of 100 records from the server about 100% faster than with the full optimized SQL command. Changing the table’s normalization and using appropriate indexes, we can improve the retrieval time for 275%.

Read More

Read Comments (3 Posted) Post Comment Permalink

Sometimes a program you have written just doesn't run fast enough. In this article I'm going to look at how (and how not) to approach such problems along with some tips for speeding things up in various cases.

Stop Right There!

The biggest mistake people make when trying to improve the performance of their programs is jumping straight in and trying to do it without first understanding where the bottleneck lies. Often the real performance issue may not lie where you think it does.

Tools for analyzing program performance are called profilers. They will tell you which functions and sometimes even which lines of the program are taking up what factor of the execution time. This is highly valuable information and can save you a lot of wasted time. Without it, you might set about optimizing a function or method that is only taking a tiny fraction of the execution time anyway.

Read More

Read Comments (9 Posted) Post Comment Permalink