[MonetDB-users] I'm looking for a fast way to write data to the DB from a scripting language.

Michalis Polakis mpolakis at gmail.com
Sun Sep 7 07:20:40 CEST 2008


Good morning Jay,

you can use the Ruby MAPI Wrapper => MAPI calls through Ruby.
It's elegant and simple and was used to implement the Ruby on Rails
adapter for MonetDB.
Plus, from what I see in the SWIG input file, the insert and copy_from
functions should be
implemented in the Ruby MAPI Wrapper.
If you want to go the Ruby way, you may find the files in the MonetDB
clients package or
at http://rubyforge.org/projects/monetdb-ror/ as part of the Ruby on
Rails MonetDB adapter.

Regards,
Michalis

-----------------------------------------------------------------------------------------------
Hi,

I have 50 million rows and 15 columns that I'd like to put into one
table. My first attempt to transfer them was through PHP using the
monetdb_query method. This is causing a lot of disk thrashing and my
throughput is about 100 rows/sec.

I get an "undefined function" error for both monetdb_insert and
monetdb_copy_from.

I would like to find a fast method, but from inside a common scripting language.

Thanks,
Jay




More information about the users-list mailing list