I think I remember a message on the UT referencing performance problems with SET DELETED and Novell 3.12. Had something to do with serializing access to tables, I think. I can't seem to find the post - search doesn't seem to be working - but I think it was within the last 6 months or so. Maybe the problem carried over to 4.x?

>I have been struggling to find answers to this for a month. Any help would be appreciated.
>
>Norvel 4.1 networked LAN with approximately 6 PC workstations running Windows 95b. Application (developed with VFP6,SP2) is installed on each workstation with tables on the server.
>Problem: The application on the workstation #1, which gets the most use, slows to a crawl - takes 4-5 minutes to get a record. I can go to another workstation and log on, open the form and find the same record in less than 2 seconds while the 1st workstation is still looking. Data entry also slows to a crawl on the 1st workstation. Warm booting the system will sometimes speed the application up but within an hour or so has slowed down again. Sometimes the warm boot doesn't even speed it up. A cold boot almost always works but, again, the system slows down within an hour or so.
>Even with the cold boot, sometimes the record search is still too slow. Records being searched as less than 50,000. All tables have been checked for Rushmore. All tables have deleted() tag.
>
>Workstation #1. Gateway Pentium 350 with 132 RAM, Video card with 8 meg, Win95b (originally came with NT but was completely reformatted to Win95b.)
>Steps taken to fix
>*Changed out network card in the workstation (packets between workstation and server were much slower than other workstations . .. changing card seemed to improve transmission speed.)
>*Plugged in another network CAT5 to this workstation, didn't make any difference
>
>I hope this isn't too confusing. Any help and ideas for further checks would be greatly appreciated.
>Linda