http://www.programmersheaven.com/blog/tags/LAN Contains the latest posts from the Programmer's Heaven blogs that are tagged with the label 'LAN' Tue, 08 Jul 2008 21:46:27 -0700 Argotic Syndication Framework 2007.3.0.1, http://www.codeplex.com/Argotic http://www.rssboard.org/rss-specification http://www.programmersheaven.com/user/josip1/blog/207-VFP-performance-in-LAN-environment/ <a href="http://89.212.41.202/postuni/clanki/articles/vfpperformance/performance1.htm">VFP performance in LAN environment</a><br /> <br /> 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%.<br /> <br /> Author: Josip Zohil, Koper, Slovenia, Josip.Zohil1@guest.arnes.si http://www.programmersheaven.com/user/josip1/blog/207-VFP-performance-in-LAN-environment/ Thu, 27 Mar 2008 11:29:36 -0700 josip1