Re: Why PHPLIB::DB sucks

Alexey Borzov wrote:

I looked at PHPLIB's current CVS code and found out that PostgreSQL driver *still* uses sequence emulation, while there are native sequences in PostgreSQL (on which this 'emulation' relies internally!). As this brain-damaged implementation wasn't fixed for the last several *years* this also shows that hardly anyone uses PHPLIB. I looked a bit closer at the code and found out that this 'emulation' actually does not use native sequences at all. Instead it creates a table for all the sequences and locks it exclusively when a need to get a next id arises. This is even more brain-damaged, exclusive lock in PostgreSQL is usually acquired only by DROP TABLE, ALTER TABLE, CREATE INDEX and similar commands.

This creates a bottleneck that will nullify all possible speed increases with this 'light' layer.