Re: Row and Page locking - time difference
Posted in 1997
Vijay R. Anisetti (rambabu@sprynet.com) wrote: : I don't think I'm. As I understand there is no difference between the : two, OS needs to know from what offset to what offset of the disk needs : to : locked, getting the info. from the disk, either thru a file : descriptor/id : or a direct physical address. Direct physical address (i assume) is the : method used by Informix-online for rawdisk handling. Irrespective of : whether : it is rawdisk or cooked file, the basic difference the row (variable) : and : page (relatively constant) will result in the difference in time it : takes : to lock, as I explained before. : Anybody with a difference of opinion or more input? Online doesn't use the OS for locking. We use our own internal locking mechanisms. So this logic doesn't apply.