read (SELECT) has to find physical position of record on disk. update too has to find physical position of record on disk. this is inefficient if it's done twice in a row, because two searches for record have to be performed. only one search would be enough and more efficient. is there any way SELECT and UPDATE can be done in in one SQL statement?
in fact, why isn't it possible to refer to records by their physicall offset on disk? as far as i know thay don't change. ____________________ http://www.email.si/