Many thanks for the Answer and I using at the moment prepared statements in java and my autocommit is off. So I need help with the Parameter Settings like Cache Size and so on.
Cheers Gert > -----Original Message----- > From: Flessner, Falko [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 30, 2003 4:56 PM > To: Gert Wohlgemuth; [EMAIL PROTECTED] > Subject: RE: many inserts > > > 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.ht> m > > 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
