Re^4: mysql, locked databases, Apache::DBI and mod_perl

[Flame]

Under mod_perl then, if I were to lock a table and have another process running at the same time, both using Apache::DBI and the same parameters, wouldn't it think of both processes as identical and thus complain when one tries to use tables that weren't locked by the other, and when one locks tables, wouldn't it undo the previous locks? I'm beginning to question the practicality of Apache::DBI in this context... perhaps I should do file locking on files named after the tables.

---

My code doesn't have bugs, it just develops random features.

Flame ~ Lead Programmer: GMS (DOWN) | GMS (DOWN)

[perrin]

There's nothing with Apache::DBI in this context. You are now asking about multiple processes. Multiple processes will never have the same database handle or the same connection. Within a single process, any time you connect with the same parameters you will get the same connction.

[Flame]

Oh, well that would settle that. I'd been wondering that off and on for a while. Thanks



---




My code doesn't have bugs, it just develops random features.

Flame ~ Lead Programmer: GMS (DOWN) | GMS (DOWN)