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