[mythtv] 0.28 MythVideo: slow loading

[Angela]

From: mythtv-dev [mailto:mythtv-dev-bounces at mythtv.org] On Behalf Of Jean-Yves Avenard
Sent: Saturday, 30. January 2016 23:04
To: Development of MythTV <mythtv-dev at mythtv.org>
Subject: Re: [mythtv] 0.28 MythVideo: slow loading

 



On Sunday, 31 January 2016, Angela <angela.schmid at wolke7.net <mailto: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/f4e1eecf/attachment.html>