Hi Jim

>Ya know, there's no denying that it could have been caching at play though my sense is still that it wasn't THE factor...
>
>You may remember that one person would report a slowness and several people would have a look-see. I'm almost sure that other runs would have been done by others on their own workstations. I seem to recall doing just that at my own workstation on a few occasions (and I trusted the report so didn't just re-run and then try different things)
>And I'd bet that these were ALL network-access queries.
>
>Keep in mind, too, that we'd be working in DOS and that our bigger workstations were ones with 32 meg. I think developers had workstations of 8 meg back then with 486-33 or 486-66. Also don't forget 10bps network at that time.
>The server was a PI-66mhz with 256MB RAM but it did have a Storageworks RAID5 array (dual SCSI) which was simply marvellous.
>
>As DBA back then the TAG on DELETED finally sunk in and I did make certain that every table had one.
>
>So it remains mysterious to me.
>
>cheers and thanks for having me dredge up some good memories.
>

It was fun until it ended so badly.