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