It usually happens when you want to join up 2 tables that do not have a link between them.
eg. If you have tables like.
// Load from the product table.and left join to client.
left join (Client)
The 2 tables do not have a field with the same name in it in both. This causes a Cartesian join
Depending on the size of the tables it will cause the error that you just described.