Goldrick, Jim said:
>
> Our admissions office locks records continuously. They're on the phone
> with students in update mode and they lock rows in several heavily used
> tables, sometimes for great lengths of time. I generally have to set
> isolation to dirty read for web apps and web reports.
Badly written application.
--
Bye now,
Obnoxio
"C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule"
- Coluche
did i mention i like nulls? heck, i even go so far as to say that all
columns in a table except the primary key could/should be nullable. this
has certain advantages, for example, if you need to insert a child record
and you don't have a parent row for it, just do an insert into the parent
table with the primary key value (everything else null), and voila,
relational integrity is preserved. but this is, admittedly, a bit
controversial among modellers.
--r937, dbforums.com