Replace multiple SELECT with INNER JOIN

j256 / ormlite-android

ORMLite Android functionality used in conjunction with ormlite-core

http://ormlite.com/

ISC License

1.59k stars 367 forks source link

Replace multiple SELECT with INNER JOIN #56

Closed ReginFell closed 8 years ago

ReginFell commented 8 years ago

Hi! I faced problem, that ormLite using multiple select instead inner join for foreign fields, and it highly slow down working with database. Is there way to use foreignAutoRefresh = true, maxForeignAutoRefreshLevel = 1 with inner join?

j256 commented 8 years ago

This is in the TODO list but not currently on the docket. It's a lot of code.