Hello Stefan, Stefan Manegold wrote, On 10/17/2012 12:07 PM:
In case the MAPI protocol and client-side data parsing and -rendering are indeed too much of an overhead even for "occasional" exports, you might want to consider the bulk export functionality as described under http://www.monetdb.org/Documentation/Manuals/SQLreference/CopyInto i.e., COPY subquery INTO file_name [ [USING] DELIMITERS field_separator [',' record_separator [ ',' string_quote ]]] [ NULL AS null_string ]
This will generate a (possibly even compressed) "DSV" (delimiter separated values) file --- obviously in the file system of your server. But if you wrap this functionality in a "export" button of your website (rather than let users type SQL literally), you can easily place the file somewhere where the user can download it via http, ftp, or alike ...
Thanks for the tip. I tried the "copy" command, and unfortunately it's not a lot faster: === sql>copy select * from bc251 into '/tmp/foo2' ; 1657032 affected rows (2m 14s) === and sadly I also found a bug related to "COPY INTO": http://bugs.monetdb.org/show_bug.cgi?id=3165 So I'm still exploring other possibilities. Thanks, -gordon _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list