search

tarekdj / db-benchmark

http://forum.nette.org/cs/14592-lean-mapper-tenke-orm-nad-dibi?p=5#p106521
0 stars 0 forks source link

Benchmark using custom query on FluentPDO library #3

Open tarekdj opened 10 years ago

tarekdj commented 10 years ago

Sample query:

'SELECT DISTINCT u.id FROM %s AS listuser CROSS JOIN %s AS u CROSS JOIN %s AS listmessage LEFT JOIN %s AS um ON (um.messageid = %d AND um.userid = listuser.userid) WHERE true AND listmessage.messageid = %d AND listmessage.listid = listuser.listid AND u.id = listuser.userid AND um.userid IS NULL AND u.confirmed and !u.blacklisted and !u.disabled'

SaWey commented 10 years ago

imho, this library only seems useful if the database is using foreign keys. Else, it's a lot like just using PDO