Hi, your question has been asked many times before, therefor I will only give a small overview of how to tune mass-inserts.
You may want to search the archive of this list at http://www.sapdb.org/7.4/sap_db_mailinglist.htm There are two common usable ways to speed up inserts: - Bundle many INSERTs into one transaction: Interfaces (JDBC, DBI, ODBC...) usualy turn on AUTOCOMMIT by default. This means, that for every insert your Harddisks need to be accessed to make sure that the data is available after a crash. By triggering a COMMIT manually and grouping many inserts in it, this will reduce I/O-load and therefor speed up your inserts. - Make use of "prepared statements": IIRC, all DB-Interfaces support "prepared statements". SAP DB spends a lot of time in parsing SQL statements. Prepared statements need to be parsed for only one time and will be feed with variable data later, as done in this perl-example: ################################################# $sth = $dbh->prepare("INSERT INTO table (field) VALUES (?)"); foreach my $field (@list) { $sth->execute($field); } ################################################# For further informations take a close look at the documentation of your Interface. Regards, falko Original from: [EMAIL PROTECTED] > A realy newbie question, > I using sapdb 7.4 and write a algorythm to analyse statistical datasets. > How can I tune the database for many inserts and also many selects. > The database shoud have over 3 Million entrys per Table. > Do you know some papers about sapdb database tuning? -- Falko Flessner SAP Labs Berlin SAP AG visit http://www.sapdb.org _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
