I’m evaluating MonetDB and importing an SQL file containing INSERT statements, so that I can populate the following table :

CREATE TABLE session

(

  cmd character varying(25),

  date bigint,

  session_id character varying(64),

  score integer,

  src_ip character varying(25),

  dst_ip character varying(25),

  tx_bytes integer,

  rx_bytes integer,

  retx_bytes integer,

  scrambling character varying(16),

  url character varying(64),

  country character varying(32),

  orig character varying(3),

  status integer

)

No index was created.

From what I can see, I’m somewhere between 20 and 40 insertions per second (Core i5, 4GB RAM, Windows7, MonetDb MonetDB5-SQL-Installer-i386-20111021.msi).

The Windows task manager shows a disk write throughput of 300 kB/s which looks like very small, processor usage around 5%.

I imported the file with mclient –u monetdb < myfile.sql

I expected to import at 200 rows/second minimum. Am I doing something wrong ?

What can be done to improve the loading speed ?

Thank you

SC