A client of mine has a problem with very slow table access. This is their situation:-

Windows NT4
Citrix/WinFrame Terminal Server
VFP5
One of their tables contains 8+ million rows.
Table size is 1.6Gb
About 100 users.

The table in question is being hit quite hard and some extremely slow responses have been measured. One operation is selecting data from the table, others are inserting into the table. Those that are inserting are *hanging* and task manager shows *not responding*. I've explained to the user that the process is too busy to respond to task manager.

Another operation that updates the table has taken all day to update about 1,000 rows.

Does anybody have any experience with this kind of slow-down? Any solutions?