That might be true, but as HoL says, the vast majority of users do use MySQL, like it or not, so if we were going to optimize basing on some specific dbms, we'd need to concentrate on it.jmpoure wrote:MySQL is not a standard database and has many inconsistencies.
Optimizing phpBB for PostgreSQL (for general audience) would be like optimizing a generic application (for general audience) for Linux, when 98% of users use Windows: that makes no sense.
Anyway, are you considering creating some kind of MOD, maybe specific to large boards running on PostgreSQL? You might skip the DBAL altogether and rewrite the db interface, and/or single queries.
(Then, the same could be made for other dbms's, MySQL first in line.)
I suppose there are people out there who may be interested.
Another thing I was wondering: why isn't the session table stored in memory? It looks like (although I'm not certain) it's the only table to be continuosly rewritten, it's little, and if data gets lost is not a big problem.