Hi: does anybody know what's the problem with the copy into of locked?
we want to use concurrent copy into to a table, seems montdb not good at this. some body says add locked, we try, but the database crached. MonetDB COPY INTO uses a parallel algorithm. The LOCKED mode is indeed for single user mode, but can be ignored. Using concurrent COPY INTO into the same table will fail, because
On 8/24/12 6:53 AM, li, xiaohua wrote: the optimistic concurreny control will allow only one transaction to commit regards, Martin
we just test like this
copy 200 OFFSET 1 RECORDS into f_activity from 'd:\bcp.txt' USING DELIMITERS '|','\n' NULL AS '' LOCKED
seems need single user mode, but how to set single user mode?
Lixiaohua
Shanghai,China
------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users