[vlc-devel] [PATCH 00/13] Execute medialib queries out of the UI thread

[Rémi Denis-Courmont]

Le mardi 24 novembre 2020, 18:52:28 EET Romain Vimont a écrit :
> > > Btw, even if indexing/preparsing is done from a separate process, it's
> > > still the same database with the same lock (so this would still cause
> > > delays).
> > 
> > No. Your design is pretty broken if the DB lock is held while preparsing.
> 
> AFAIU (I did not investigated in detail), during indexing there are a
> lot of successive writes (enqueued), and a single "row count" or "get
> item at" is executed after the write queries posted before.

Point is that the preparser  should not be holding the DB lock while 
preparsing, but only while storing the results of a finished preparse. So then 
preparsing I/O won't (indirectly) block DB readers anyway.

-- 
Rémi Denis-Courmont