MonetDB COPY INTO uses a parallel algorithm.
On 8/24/12 6:53 AM, li, xiaohua wrote:
> 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.
The LOCKED mode is indeed for single user mode, but can be ignored.
Using concurrent COPY INTO into the same table will fail, because
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
>
------------------------------------------------------------------------------
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