manage connection to same table

[eklee]

Hi,

How came manage more efficiently when 2 or more application will access to same table, from different user at the same time?

Because the problem I have now is, if 2 user deal with same table at the same time, then there might have the possibility either site can't update it. Seem like table lock for either unfinish transaction?

Thanks
Louis

[Anon]

Your right, table lock is the way to go. IF you dont want to do that, you might have to create a semaphore table. This wont be as reliable though.

[[deleted]]

Table locks are only usefull if you can't use transactions.

Rule #1 in databases, never lock anything unles you have a valid reason for it. And you rarely do.

As for unfinished transactions; they don't exist with PHP. Every transaction is ended when the script ends. (rolled back by default ofcourse)

If you're still using mysql without InnoDB: start using InnoDB. If you're already using somehting better than mysql, use transactions.

[eklee]

where can I look for more information about InnoDB? I have no idea what is that.

THanks
Louis