The swiki says that making JOINs into a where clause is more efficient,
since sqlite translates the join condition into a where clause. It also
says that you make queries more effiecient by minimizing the number of
rows returned in the FROM clause as far to the left as possible in the
join. Does the latter matter if you are translating everything into a
where clause anyway?
--Keith
******************************************************
- I'm not a professional; I just get paid to do this.
- Things I've learned about multithreaded programming:
123... PPArrvooottieedcc ttm ueelvvteeirrtyyhtt
rhheiianndgge dwi hnpi rctohhg eri aslm omscitanalgt
iowcbh,je engceltvo ebwrah lip,co hso srci abonlt ehb
.ee^Nr waicscee snsoetd 'aotb jtehcet -slaomcea lt'il
m^Ne from two or more threads
******************************************************