Use of UNION vs UNION ALL

[marianokamp]

Hey Travis.

Looking at the code I am not sure if you are still running this, but I saw that you posted a recent version to Google Play.

In the sql statements I used a lot of UNIONs for some of the major SQL statements. Meanwhile I think it should work with UNION ALL as well and that may very well be faster. To the best of my knowledge UNION would check for duplicate rows, which there shouldn't be, and UNION ALL wouldn't.

Just a thought.

[travistabbal]

Interesting. Thanks Mariano, I'll check it out.

…

On Mar 17, 2017 3:03 PM, "marianokamp" ***@***.***> wrote: Hey Travis. Looking at the code I am not sure if you are still running this, but I saw that you posted a recent version to Google Play. In the sql statements I used a lot of UNIONs for some of the major SQL statements. Meanwhile I think it should work with UNION ALL as well and that may very well be faster. To the best of my knowledge UNION would check for duplicate rows, which there shouldn't be, and UNION ALL wouldn't. Just a thought. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#34>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAXFmSBKuXarPhd5VDoMQhup_t2fz2Y2ks5rmvU2gaJpZM4MhGYK> .

[BenjaminHCCarr]

thanks to both @marianokamp and @travistabbal. I recently introduce someone to Graze/Rob, and their only complaint was the "Gingerbread" like UI. But there are many of us still in love with this product.

Making it faster would be amazing! Thanks for the UNION --> UNION ALL suggestion @marianokamp.