Subject Writing to tables, ignoring concurrency
Author Nigel Weeks
I know it's bad, but in this case, it doesn't matter.

It's a page counter on a very busy site, and it's always deadlocking.

I have a stored procedure that selects the value of a field, adds one,
writes is back, and suspends the new count

The trouble is, it sti takes too long, and deadlocks are a-plenty

If I start a transaction with parameters like "no-wait shared write",
Claudio's site:
says that any transaction can write to any table, even those used by other

Does it work? Has anyone used it?

If this is the case, I'll have to add the functionality to the PHP
interface - it doesn't have it yet...(Adding
isc_tpb_shared/isc_tpb_protected options to transaction initialisation)


Nigel Weeks
15 Wellington St. Launceston Tas 7250
Ph. 61 3 6334 6664
Fax. 61 3 6331 7032
Email. nigel@...