For the fastest import it is best to use the import.php automation script (or if working in conjunction with the Automation Tool the cron.php which also performs an import of all feeds. This is because importing all feeds begins with a TRUNCATE (empty) operation on the products table, which saves having to do a DELETE FROM which is often the slowest part of the import process.
If your main concern is the period that your site is not showing products during the import there is a popular modification described in this thread that imports into a temporary table and then instantly "switches" them over once complete so the site is not down at all...
Hi framor,
For the fastest import it is best to use the import.php automation script (or if working in conjunction with the Automation Tool the cron.php which also performs an import of all feeds. This is because importing all feeds begins with a TRUNCATE (empty) operation on the products table, which saves having to do a DELETE FROM which is often the slowest part of the import process.
If your main concern is the period that your site is not showing products during the import there is a popular modification described in this thread that imports into a temporary table and then instantly "switches" them over once complete so the site is not down at all...
Cheers,
David.
--
PriceTapestry.com