>>>I have determined that the major cause of the delay was the speed of the network/server combination. I have since moved the project to a dual-pentium NT server, which has cut search time by about 65-75% for the average search.
>>
>>Sure! Throw more hardware at the problem.
>>
>>While your at it, why not get a quad-processor DEC Alpha thingy. Give it 1Gb of memory. Hell, throw in a 9Gb RAID-5 with stripes (and studs and a nice peppermint flavor...) for good measure.
>>
>>Seriously, we all know that a bottleneck is still a bottleneck even on a Cray-2. I think more than hardware, solid design and good programming should be our focus as developers.
>>
>>Anyway, if it works for you, then it works for you! Forgive me for being hyper-idealistic here. =)
>>
>>Peace,
>
>Oh great, thanks Alistair... I just added 16 Megs of memory to my PC tonight & now I have to deal with a guilt trip? (G)
>
>FWIW I went from 32 to 48 -- YES! (s)
>
>Tom


If all of my PCs had 48 megs I could keep the whole table in memory! Hmmm... where'd that purchase order go????


-Craig

;)