Is mysql capable of handling joins on really large tables?
I am having a problem working with large amounts of data. I tried to join a table with 1 million records to a table with 100,000 records and the join 'ate up' all the memory in the machine so that everything just died.
Mysql is an enterprise database but I have no idea if it can handle database joins on these types of scale.
Is there a way to help it out in these situations? I'm sure indexing will help but is there anyway of breaking a join down into blocks or steps