>At a certain customer site (running Windows XP with 1GIG network gear), starting a form with a Dropdown Combo Control that loads 12,000 record, takes more than 20 seconds. Opening the same form on the Server, takes only couple of seconds.
>
>He has had the GeekSquad there couple of times and they've said the network is fast enough! and the problem is with the VFP application. Any suggestions ?
>
>Thanks .
Of course it will be slower on the network than on the local disk. The problem could be with optimization, especially if those 12,000 records are a subset of a much larger group. Check the indexes that are used for selecting the data. It may also help to step through the program and see exactly what command is slower. Is it the SELECT - SQL command that selects those records? In this case, creating additional indexes - or deleting indexes in some cases - may help.
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)
