INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: JR Media Center slow search and tagging for large database  (Read 2650 times)

chriswale

  • World Citizen
  • ***
  • Posts: 173
JR Media Center slow search and tagging for large database
« on: January 25, 2012, 12:45:24 am »

Hi,

JR Media Center list search and tagging is very slow with a large databases of music - is this normal? or is there something I can do to prevent the slowdown?
The library in question contains appoximately 140000 songs. A smaller library of 20000 songs works fine with no noticable slowdowns.

The above mentioned slow down has been noticed over the last couple of years in versions 15 to 17 of JR Media Center, on different computers and with different hard drives hosting the library.  My current computer is very high spec and running 64bit Windows 7 - the library is hosted on a local drive.

Any suggestions would be appreciated.

Chris
Logged

phalanthus

  • Galactic Citizen
  • ****
  • Posts: 461
Re: JR Media Center slow search and tagging for large database
« Reply #1 on: January 25, 2012, 01:13:31 am »

 ;D ;D

not a problem with 99000 files
certainly beats any of the competition imho
Logged

rjm

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 2699
Re: JR Media Center slow search and tagging for large database
« Reply #2 on: January 25, 2012, 02:06:15 am »

I have about 300,000 files in my library on a 6 year old XP system and I find all searches take less than 1 second.

If you provide some more information I'm sure we can improve your search performance.
Logged

MrC

  • Citizen of the Universe
  • *****
  • Posts: 10462
  • Your life is short. Give me your money.
Re: JR Media Center slow search and tagging for large database
« Reply #3 on: January 25, 2012, 11:14:58 am »

Highly likely your A/V software is interfering...
Logged
The opinions I express represent my own folly.

vagskal

  • Citizen of the Universe
  • *****
  • Posts: 1227
Re: JR Media Center slow search and tagging for large database
« Reply #4 on: January 25, 2012, 11:32:21 am »

I too experienced lagging when tagging in my 130k files music library. I usually did tagging with split views (2 views) consisting of pane views each with 11 panes, often construed from expressions. Saving a change to just one song could take several seconds during which time MC was unresponsive, so I experimented a bit. (Slow writing to file tags, or antivirus protection, was not the issue, since changing a field was equally slow if write changes to file tags was turned off.)

Tagging with just a single view with the 11 panes view was just, or at least almost, as slow as before. Tagging with a single categories view, even with the file list shown, was, however, almost instantaneous (but not an optimal environment to tag in). I also discovered that having a spilt two views setup where the panes view was hidden and only the categories view visible meant that tagging was as slow as with only the panes view. Having multiple tabs did not affect tagging performance.

Since I want to tag with a panes view I experimented further and found that a panes view seems to be faster for tagging the fewer items there are in the panes (at least with no bi-directional filtering). I therefore removed the two panes with the most items (92K and 35K items respectively). I also converted the very first pane to a search list with only a couple of items that will when selected show only a subset of the total number of files in the subsequent panes and in the file list. I furthermore moved the remaining pane with the most items (27k) to the right so that it is more likely to be fewer items in that pane when tagging (because something is selected in the panes to the left of that pane). Now tagging is fast once I make some selections in the panes to the left.

To summarize: Try to avoid having panes with very many items. Whenever feasible sort the panes so that panes with fewer items are to the left and make as often as you can selections in the leftmost panes. (I am of course talking about horizontal panes view.)

At least these guidelines helped me and tagging is now fast (but not as optimal as I would like).

I do not search very often and had not experienced any performance issues with searches.
Logged

Matt

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 42442
  • Shoes gone again!
Re: JR Media Center slow search and tagging for large database
« Reply #5 on: January 25, 2012, 11:37:27 am »

For performance, avoid using complicated expressions (or expression-based fields) to build views.

Start with a simple artist / album view.  Then add complexity slowly to find the bottleneck.

140,000 files should not be slow.
Logged
Matt Ashland, JRiver Media Center

vagskal

  • Citizen of the Universe
  • *****
  • Posts: 1227
Re: JR Media Center slow search and tagging for large database
« Reply #6 on: January 25, 2012, 11:55:30 am »

For performance, avoid using complicated expressions (or expression-based fields) to build views.

I willingly admit that this must have been the root cause of my tagging performance issues. I know MC is too powerful for my own good. But where is the fun if I cannot use all the wonderful expression capabilities, at once. Luckily I found a working middle way.

 ;)
Logged

Matt

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 42442
  • Shoes gone again!
Re: JR Media Center slow search and tagging for large database
« Reply #7 on: January 25, 2012, 12:01:52 pm »

I willingly admit that this must have been the root cause of my tagging performance issues. I know MC is too powerful for my own good. But where is the fun if I cannot use all the wonderful expression capabilities, at once. Luckily I found a working middle way.

 ;)

It's a mixture of amazement and horror when I get a library backup from somebody as smart as you.

Piles of views, most with over 10 panes, most panes built around huge expressions, all working against 100,000+ files :o

Logged
Matt Ashland, JRiver Media Center

MrC

  • Citizen of the Universe
  • *****
  • Posts: 10462
  • Your life is short. Give me your money.
Re: JR Media Center slow search and tagging for large database
« Reply #8 on: January 25, 2012, 12:07:26 pm »

The horror.... THE H O R R O R...
Logged
The opinions I express represent my own folly.

rjm

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 2699
Re: JR Media Center slow search and tagging for large database
« Reply #9 on: January 25, 2012, 12:10:26 pm »

And avoid having playlists in panes.

Editing playlists via panes is a very handy feature but is slow so I have special views for playlist editing and only use them when needed.
Logged

vagskal

  • Citizen of the Universe
  • *****
  • Posts: 1227
Re: JR Media Center slow search and tagging for large database
« Reply #10 on: January 25, 2012, 12:15:13 pm »

Piles of views, most with over 10 panes, most panes built around huge expressions, all working against 100,000+ files

Thanks for making all this - almost - possible! Looking forward to all the new functions I am sure you are planning.
Logged
Pages: [1]   Go Up