[Cranial]

So, I'm not sure when it started happening but my Movies Library is taking an extremely long time to open.

I'm running MySQL and Thumbnails Path Substitution with everything based on my QNAP NAS.

It currently takes approx 50 seconds or more to open the Movies section.

I'm using Eden 11.0. Confluence skin.

So far I've tried:

Dumping all non needed add ons.
Dumping guisettings.xml and starting fresh.
Removing XBMC completely and starting fresh.
Commenting out thumbnail path substitution.

Nothing has worked so far. Still takes ages to load Movies.

I currently have approx 750 movies and 60 TV Shows (4000 episodes).

Here's a link to a log file from the ATV2. I started XBMC, accessed 'Movies' . Returned to home screen then exited XBMC.

Pastebin Log

Any assistance or ideas would be greatly appreciated, as it stands it's making the ATV2 almost unusable.

[Memphiz]

did you read mysql tips in the wiki?

[Cranial]

did you read mysql tips in the wiki?

Sorry, I forgot to mention, yes I've read the wiki. Basically server side it's skip-name-resolve right?

I've done this and upped the cache and buffer size etc: MySQL My.Cnf

I've also applied GRANT ALL ON *.* TO 'xbmc'; to MySQL.

Here's a link to my Video Database file: SQL Video DB Zip file if that's any help.

I'm trying to avoid dumping my database and rescanning but I will try that if anyone thinks it might help.

*edit*

And here's a paste bin of my advanced settings from the ATV2: Advancedsettings.xml

[Cranial]

*Bump*

[jmarshall]

It'll almost certainly be the thumbnails that's causing the slowdown. Disable the pathsubstitution as a test.

[Cranial]

It'll almost certainly be the thumbnails that's causing the slowdown. Disable the pathsubstitution as a test.

I already did that, but I'll give it another go to see if something odd was going on.

[Cranial]

Copied all the thumbs to local on the ATV2, then removed the path substitution. It did improve the speed, but very very slightly. I'm still thinking it's not the problem.

Any other ideas?

[drunet]

Just to ask the question: you have XBMC installed for a bit of time with no issues and then just recently the speed issue started?

Is it possible that something inside your network is the issue? Has any of that changed?

[Cranial]

Just to ask the question: you have XBMC installed for a bit of time with no issues and then just recently the speed issue started?

Is it possible that something inside your network is the issue? Has any of that changed?

I wish, it'd be easy then. No, my network is fine. Nothing has changed there. All video streaming etc. is working perfectly. I'm really stuck on this.


Guess I'll try dumping the databases and starting from scratch...

[suhawk14]

Hi - were you ever able to resolve this issue?

I'm seeing what looks to be the same symptoms on my ATV2. Looking through your debug log it looks almost the same as mine:

1. Query against movieview
2. Large gap of time
3. Saving fileitems [videodb://1/2/]

Does anyone know what's going on in that gap?

[jmarshall]

Between those it's:

1. Doing a query to retrieve streamdetail information for each item in the list.
2. Hitting the filesystem for art for each item in the list.

If either are over mysql then it'll most likely be slow. You should be able to trace what's happening on your network to confirm this.

Cheers,
Jonathan

[Cranial]

Between those it's:

1. Doing a query to retrieve streamdetail information for each item in the list.
2. Hitting the filesystem for art for each item in the list.

If either are over mysql then it'll most likely be slow. You should be able to trace what's happening on your network to confirm this.

Cheers,
Jonathan

Changing to local thumbnail storage helped a little bit with my setup, but obviously this isn't as convenient when using shared database, as you need to set up another process to copy the thumbnails around to devices.

So a part of the delay is retrieving stream details? Can this be improved by scraping details for all media and storing it in the individual nfo files? (Most of my media already is), or will XBMC still retrieve stream details from the media files on access?

[jmarshall]

It's retrieving it out of the database, not out of your files, so no, having it in the nfo file won't make any difference here.

[Cranial]

It's retrieving it out of the database, not out of your files, so no, having it in the nfo file won't make any difference here.

Copy that. Thanks for the info.

[suhawk14]

Between those it's:

1. Doing a query to retrieve streamdetail information for each item in the list.
2. Hitting the filesystem for art for each item in the list.

If either are over mysql then it'll most likely be slow. You should be able to trace what's happening on your network to confirm this.

Cheers,
Jonathan

Great, thanks for the info. The library is stored on MySQL, so I'll stick some tracing on and see what it's doing.

Also, the thumbnails are being read over the network (I've got path substitution set up) and a quick test of this showed that it did help a bit.