Hi,

I've got the following question :

I wrote a little odbc app to insert a huge amount of data to a testtable.

// Tablestructure
create table testtable1 (
 id integer primary key,
 name varchar(20),
 firstname varchar(20))

inserting 10000 lines into a simple testtable takes about 25 sec ( with 
AUTOCOMMIT on)
inserting 10000 lines into this table                  takes about 16 sec 
( with AUTOCOMMIT off)

inserting 10000 lines into a postgres-db on the same host like maxdb takes 
only 5 sec ( with AUTOCOMMIT off)

Why are there so big differences between sapdb and postgresql ?

Best regards

tom

Reply via email to