This fixes the way Magento imports data as it just keeps adding ‘straight join’ to the array which uses a lot of memory if your importing a lot of products and will kill the import.

Replace this function in /lib/Varien/Db/Select.php

This has been fixed in the next update and a discussion can be seen here...

http://www.magentocommerce.com/boards/viewthread/113901/