UNION and sort? (also, property queries where no relationship exists)

[clem]

Checkout:

Best practices for queries that can take hours to complete

Another link on query optimizations: I wasn't clearly your question on time out... But if you set the timeout to 0, it won't timeout:

One tip I learned from the video, is you can move up the LIMIT command so that the query will end earlier (which is different from SQL.). I haven't quite got the hang of it myself, so I'm not sure exactly how to transform your query.