Re: Re[2]: Table locking

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi...

I want to say some words about the "Table Locking" problem.

I had a problem something like this one, I find solution for this by locking
only the item that will updated. I added two areas one that has a value 0 or
1 giving it is currently used by someone, and second time it is started to
use, default 0. When someone trying to update the item, first area has the
value 1 and the second has the current time. After update completes, ifrst
has the value 0, and second also 0.

So if someone tries to update the area first system will chack and if
someone is updating the item it will not give permission for this. Also it
will chack the time if update is out of time (ex:more than 15 minutes) it
will reset the time section and will give permission to update this item.

This will provide people to see all other table elements ather then the
updated.

It worked for me...

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux