[mythtv] 0.28 MythVideo: slow loading

[Jean-Yves Avenard]

On Sunday, 31 January 2016, Angela <angela.schmid at wolke7.net> wrote:

> Hello
>
>
>
> > If you toggle the Change View -> Browse Library/Browse Filesystem menu
> option does it make any difference?
>
> I always have browse library set, it takes a lot of time to spin up all
> disks.
>
>
>
> Logged with –v general,file,network,database --loglevel debug
>
> The delay is after loading all metadata.
>
>
>
> 2016-01-30 14:38:46.427454 D [1827/1827] CoreContext mythdbcon.cpp:779
> (seekDebug) - MSqlQuery::next(DBManager1) Result: "title = Globe
> Destinations, director = Unknown, studio = , plot =   ……. insertdate =
> 2016-01-24T09:22:16, processed = 1, contenttype = TELEVISION"
>
>
>
> 2016-01-30 14:38:56.347149 I [1827/1827] CoreContext mythdbcon.cpp:709
> (exec) - MSqlQuery::exec(DBManager1) SELECT dirname,hostname FROM
> storagegroup WHERE groupname = 'Videos'  <<<< Took 0ms, Returned 1 row(s)
>
> 2016-01-30 14:38:56.347170 D [1827/1827] CoreContext mythdbcon.cpp:779
> (seekDebug) - MSqlQuery::next(DBManager1) Result: "dirname = /store/video/,
> hostname = fe1"
>
> 2016-01-30 14:38:56.347497 I [1827/1827] CoreContext mythdbcon.cpp:709
> (exec) - MSqlQuery::exec(DBManager1) SELECT data FROM settings WHERE value
> = 'videostartupdir' AND hostname = fe1 <<<< Took 0ms, Returned 1 row(s)
>
> 2016-01-30 14:38:56.347506 D [1827/1827] CoreContext mythdbcon.cpp:779
> (seekDebug) - MSqlQuery::next(DBManager1) Result: "data =
> /var/lib/mythtv/videos"
>
>
>
>
>
>
>
> Reverted cb2561c41fa7378a16af0de1ccec1dcdb9edc56c
>
> Use natural sort for presenting content
>
>
Natural sort was already enabled on 0.27

Are you saying this is what's causing the delay on 0.28?

My suspicion was with the new recursive search that was added in 0.28. This
didn't get back ported to 0.28. And afaik, is really the only difference
between 0.28 and 0.27.


> Now it takes 2 seconds, without debugging.
>
> With fixes-0.27 from beginning December it was less than 0.7 seconds.
>
>
>
> Anything else I can optimize?
>
>
>
>
If you think you can sure.
Sure.

Caching the results on the backend may help if that's what the problem is.


> Angela
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-dev/attachments/20160131/81ed636e/attachment.html>