> I'd love to build a 300 million row Table, short of the that > the biggest possible on a desktop machine.
> I am using > > - 800 Mhz, 300MB+ RAM machine with a baracuda IDE drive > - Wink2K SP3 > - Kernel 7.4.3, Build 010-120-035-462 > - ODBC > - local connection > - Database instance: SAP DB OLTP > - single log mode set to off. > - 1GB data volume if you are interested in an ODBC mass insert benchmark i have no further suggestions. > I am looking for raw INSERT speed. You should use the fastload command of SAP DB Loader for this task http://www.sapdb.org/7.4/htmhelp/e2/55683ab81fd846e10000000a11402f/frameset.htm ->SAP DB Loader: Commands and SQL Statements -> Commands for Loading and Unloading -> FASTLOAD Command regards -- Hans-Georg Bumes SAP DB, SAP Labs Berlin http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
