Related...but on a slightly different topic...The main function for
the database I'm using is to do selects. It's basically a read only
db. I know there is no way to disable locking...but is there a lock
option that will leave the db in the least locked state...if you catch
my drift. I don't care about threads doing dirty reads because the
data won't change...

Would setting the db to read only have an effect on this. Which
server setup is best for this kind of scenario...multiple processors
doing loads of reads?

Thanks again
C