[kdepim-users] akonadi fsck fails

[J. Roeleveld]

On Tuesday, August 25, 2015 09:24:07 AM Pablo Sanchez wrote:
> [ Comments below, in-line ]
> 
> On 08/25/2015 09:17 AM, J. Roeleveld wrote:
> ::: 1 :::
> > delete from pimitemflagrelation
> > where not exists
> > 
> >     (select 1 from pimitemtable where pimitemtable.id =
> > 
> > pimitemflagrelation.pimitem_id);
> > 
> ::: 2 :::
> > delete from pimitemflagrelation
> > 
> >     where pimitemflagrelation.pimitem_id in (
> >     
> >           select pimitem_id
> >           from pimitemflagrelation
> >           left join pimitemtable
> >           
> >             on pimitemflagrelation.pimitem_id = pimitemtable.id);
> 
> FYI:  (2) is better than (1).  :)

Both provide the same result.
(2) is clearer to read.

I just want to know which fix-option is preferred:
- Rewrite the DELETE-statement as above (version 2)
- Split the delete-list over smaller chunks

--
Joost
_______________________________________________
KDE PIM users mailing list
Subscription management: https://mail.kde.org/mailman/listinfo/kdepim-users