During several relaunches I had to migrate thousands of content items (mostly news articles) from Typo3 (WTF?!??) sites to the new (Drupal-based) ones. Because Drupal's Bulk Import API or the Feeds module seemed way to overdose, I decided to accomplish that using only MySQL's toolbelt: Stored Procedures.
CALL do_batch_import(0, 1000);