Yes, multi table select could be used, but I make some data processing
before paging (like name+' '+secondname ), and some other more.
My question is how to cache select depend on query? (make bigger
cache?)
Cache stat shows 70-80% hits (it shows stat of random thread ), but
each search ( page wit
Would it work for you to do a 3 table JOIN and then it would be one
select?
You put the ON clauses in the same place as the WHERE clause with &
between e.g.
db((db.name.id==db.ref_table.name_id) &
(db.secondname.id==db.ref_table.secondname_id)).select(.
where ref_table is your third table in
2 matches
Mail list logo
