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