Hi, On 29-11-2006 09:33:27 +0100, JLP00993@correo.aeat.es wrote:
Hello:
I would try to load about 300.000.000 registers with 80 fields each one (150 GBytes) in Monet V4.12.0 database.
I think this is not going to work with current MonetDB very well.
I saw in mail lists the next bulk load method:
COPY <number> RECORDS INTO <table> FROM stdin USING DELIMITERS '\t';
I have my data in an ASCII file but my fields are not delimited by any character, they are fixed length.
Ah... as far as I know we don't have parsing for that. The solution I'd give is to convert your file in a pipe with awk or something before giving it to MapiClient.
These are my questions:
Where can I find full documentation about COPY command?.
I'm affraid nowhere at the moment.
In my case, which is the most efficient way to do the bulk load?.
The COPY INTO command is the most efficient was to insert data into MonetDB/SQL.