several queries as opposed to a single query

[cast mitigation]

I have been wondering what would put less overhead in the database: a single very long query that would end up joining up to 3 tables with millions of records each or split it up into several queries?

just curious

thanks in advance

[Brett_Tabke]

Depends entirely on the hard ware.

The easiest way to know?
Test it.