Hi Skarai, it's just based on my experience, not based on math. A table which contains 1000 to 5000 records (say 10 to 100 columns) on 100M LAN normally takes 1 to 5 seconds to download from DB2 on AS/400 using iSeries OLE DB driver or from Informix on Unix using Informix native OLE DB driver into a staging table with no index in SQL Server on Windows 2000 or 2003 server, configured with RAID 5 for MDF and RAID 1 for LDF using 15k RPM disks, running on DELL 2850 with 8 MB memory, performed using DTS or SSIS with no transformation or scripting (just plain direct column to column mapping).

Kind regards,

Vincent Rainardi