Deleting a large number of records from a mensia table

Sean Hinde sean.hinde@REDACTED
Wed Nov 30 01:28:49 CET 2005


Hi,

There is nothing to stop you deleting the records from a RAM only  
mnesia table with ets:select_delete directly. If you also hold things  
on disc then this will not help very much (the disc will not be  
updated).

Regards,
Sean

On 28 Nov 2005, at 17:48, Valentin Micic wrote:

> How about mnesia:activity with ets access context? Would it be  
> possible to access select_delete mechanism then?
>
> V.
>
> ----- Original Message ----- From: "Sean Hinde" <sean.hinde@REDACTED>
> To: "Sebastian Bello" <sebastian@REDACTED>
> Cc: <erlang-questions@REDACTED>
> Sent: Monday, November 28, 2005 3:24 PM
> Subject: Re: Deleting a large number of records from a mensia table
>
>
> Hi,
>
> You can't. ets has the select_delete mechanism, but mnesia does not
> export this to its own API.
>
> Sean
>
> On 28 Nov 2005, at 12:39, Sebastian Bello wrote:
>
>> Hi all,
>>
>> how can I delete a large number of mnesia records -which match a   
>> certain criteria- without having to select them (to avoid a big   
>> memory copy of them)?
>> Thanks,
>>     Sebastian-
>>
>> PS: excuse me if this question has already been asked/answered
>>
>> <01f301c5f418$b9fd60f0$dc00a8c0>
>> Prepaid Expertise - Programmable Switches
>> Powered by Ericsson Licensed Technology
>> Sebastián Bello - Engineer - Development Center - IN Switch   
>> Solutions Inc.
>> Headquarters - Miami-U.S.A. Tel: 1305-3578076 Fax: 1305-7686260
>> Development Center - Montevideo - Uruguay Tel/Fax: 5982-7104457
>> IN SWITCH EMEA Phone: +33 0 6 0335 9427 - Fax: +33 0 4 93655773 /  
>> emea@REDACTED
>> IN SWITCH ASIA Phone: +92 51 2800397/8- Fax: +92 51 2800399/  
>> inswasia@REDACTED
>> e-mail: sebastian@REDACTED
>>
>>
>
>




More information about the erlang-questions mailing list