>I am fairly new to Visual Foxpro (5.0) and have inherited an application that facilitates the development of audio programs. Users create and change programs using a grid that contain text info about the cuts in the program. This grid is populated using a local view of two tables on a file server. Users need to resequence the cuts frequently while developing a program, which is done by changing a sequence number to a fractional value. For example, to move cut 3 between cut 1 and cut 2, they change the sequence number of cut 3 to '2.5'. They sometimes insert multiple cuts using, for example, 2.1, 2,2, and so on.
>
>When the user saves the program, the sequencing data is copied into an array, which is then sorted by sequence number. The sequence number is changed to an integer, and replaced in the source table from the array. For longer programs (200-300 cuts) this originally took a minute or more, which was way too slow. I have managed to cut that back to 15 seconds on average, but that is still too slow. The users have demanded that resequencing take no more than 5 seconds.
>
>My question is twofold: 1) is it reasonable to expect Visual FoxPro to perform 300 database updates in less than 5 seconds; and 2) if so, how can I achieve this? Offline views are not an option, because a future requirement is to be able to insert a cut, which is not allowed for offline views.
>
>Thank you in advance for any help. I have already used many tips I have found here and have immense respect for the brainpower assembled here.

300 updates in 5 seconds is a bad score for VFP unless computers are really slow. How do you update ? Some part of code you use for updating might help us to see what's going wrong.
Cetin