Hi Nic,

use COPY which is recommended and fastest way to load data from text files. http://monetdb.cwi.nl/SQL/Documentation/Data-Manipulation.html#Data-Manipula...

You can even directly import gzip files: COPY INTO mytable FROM '/path/file.txt.gz' USING DELIMITERS '|','\r\n';

You could also import SQL directly with mclient but this is slower: mclient -l sql -u username -d databasename < myfile.sql

Vlad

On Wed, Apr 13, 2011 at 5:21 PM, Nic Chidu nic@chidu.net wrote:

What way do you suggest for bulk uploading data?

Thanks.

Nic

---

Forrester Wave Report - Recovery time is now measured in hours and minutes not days. Key insights are discussed in the 2010 Forrester Wave Report as part of an in-depth evaluation of disaster recovery service providers. Forrester found the best-in-class provider in terms of services and vision. Read this report now!  http://p.sf.net/sfu/ibm-webcastpromo _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users