[mythtv] 0.28 MythVideo: slow loading

Sat Jan 30 14:19:54 UTC 2016

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

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?

Angela

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

On Saturday, 30 January 2016, Angela <angela.schmid at wolke7.net <mailto:angela.schmid at wolke7.net> > wrote:

Hello
Upgraded my test-disk from 0.27.5 to 0.28.

On 0.27 the gallery loads immediately. With 0.28 it takes 10 seconds. 8000
movies.
I didn't change any settings.

Seeing exactly the same thing fwiw. 

Takes more than 10s here though; almost 15 even on a quad core 3Ghz i5

Any ideas?

Will look into it at some stage. 

Angela

_______________________________________________
mythtv-dev mailing list
mythtv-dev at mythtv.org <javascript:;> 
http://lists.mythtv.org/mailman/listinfo/mythtv-dev
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-dev/attachments/20160130/8f1aaf9b/attachment.html>