Guillaume Theoret wrote:
Hi, I have a question about insert performance.
At first, with an empty table, it took a little over 1 second (around 1.5) to insert 1000 rows. Now, with 5.2MM rows, it's taking ~65s.
Is this to be expected?
Yes, the table space grows over time, which calls for a re-alloc operation. This may involve writing/reading. The fastest way to insert 5.2 M records is to use the SQL query COPY 5200000 RECORDS INTO tt FROM....
Thanks, Guillaume
------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users