Domas Mituzas midom.lists@gmail.com wrote:
[...]
Does anyone know a DBMS where joining with limits actually works?
*shrug*, maybe PG does it properly, maybe MySQL 5.x does it properly, maybe sqlite does it properly. [...]
BTW, is it feasible to replicate from MySQL to PostgreSQL (or SQLite :-)) in a continuous way so that one or two cuckoo's eggs could be planted in the database farm? Though probably undesirable from an operations viewpoint, a real- time performance benchmark would be really cool :-).
Tim