Hi,

I am also new to MonetDB, but COPY .. INTO is probably your best bet.

http://www.monetdb.org/Documentation/Manuals/SQLreference/CopyInto

It is quite fast, and you can use a database dump to see example of the syntax / try it out:

http://www.monetdb.org/Documentation/UserGuide/DumpRestore

Cheers,
- Philippe

On May 23, 2011, at 4:54 PM, julio Puebla wrote:

I'm new using MonetDB, I have a question:

What
 is the best way to add hundreds or thousands of rows per second on a table MonetDB?


Thanks in advance.

------------------------------------------------------------------------------
vRanger cuts backup time in half-while increasing security.
With the market-leading solution for virtual backup and recovery, 
you get blazing-fast, flexible, and affordable data protection.
Download your free trial now. 
http://p.sf.net/sfu/quest-d2dcopy1_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users