INTERACT FORUM

Please login or register.

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

Author Topic: Huge database  (Read 1090 times)

colombo riccardo

  • Recent member
  • *
  • Posts: 7
Huge database
« on: January 27, 2024, 05:31:18 am »

Hi everyone, I'd like to know what your experience is with using huge databases.
right now in jriver I have uploaded 442903 music tracks in flac and I still have to slowly tag about seventy-five thousand albums.
Logged

JimH

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 72549
  • Where did I put my teeth?
Re: Huge database
« Reply #1 on: January 27, 2024, 05:45:06 am »

Are you having a problem?  If so, please describe.  Also describe your setup.
Logged

colombo riccardo

  • Recent member
  • *
  • Posts: 7
Re: Huge database
« Reply #2 on: January 27, 2024, 06:04:29 am »

Right now i have no problem with version 23, i also have version 31 in Mac book air with Mac osx 10.13 8gb RAM, but in this Moment i am using only version 23.
Logged

zybex

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 2675
Re: Huge database
« Reply #3 on: January 27, 2024, 06:13:31 am »

That's fine, here's some reports:
https://yabb.jriver.com/interact/index.php/topic,84637.msg578228.html#msg578228
https://yabb.jriver.com/interact/index.php/topic,136529.msg946211.html#msg946211

I've seen 20 million tracks mentioned somewhere. The database is loaded into memory, so it's better with 16 or 32 GB RAM.
Logged

JimH

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 72549
  • Where did I put my teeth?
Re: Huge database
« Reply #4 on: January 27, 2024, 06:14:30 am »

You have a license for MC32.  You could download and try it.  It should behave at least as well with your library.
Logged

colombo riccardo

  • Recent member
  • *
  • Posts: 7
Re: Huge database
« Reply #5 on: January 27, 2024, 06:59:14 am »

I read that in MC32 there Is a new feature

A new feature of Media Center 32 is that the most recent library from a previous major version will automatically be loaded and restored into Media Center 32 the first time it is run.

I ask if there Is the option of not tò do this (the most recent library Is not automatically loaded and restored the First time It Is run)
Logged

colombo riccardo

  • Recent member
  • *
  • Posts: 7
Re: Huge database
« Reply #6 on: January 27, 2024, 01:32:57 pm »

The database is loaded into memory, so it's better with 16 or 32 GB RAM.

where can I see how much space the database takes up in ram?
Logged

eve

  • Citizen of the Universe
  • *****
  • Posts: 689
Re: Huge database
« Reply #7 on: January 27, 2024, 02:24:49 pm »

I'd say scale wise, it's a large library but nothing troublesome for JRiver.
Like one of the linked threads mentioned, when I used JRiver for music maybe 6+ years back, I was sitting at maybe 2 million track entities and performance wasn't a huge concern.
Logged

eve

  • Citizen of the Universe
  • *****
  • Posts: 689
Re: Huge database
« Reply #8 on: January 27, 2024, 02:26:34 pm »

That's fine, here's some reports:
https://yabb.jriver.com/interact/index.php/topic,84637.msg578228.html#msg578228
https://yabb.jriver.com/interact/index.php/topic,136529.msg946211.html#msg946211

I've seen 20 million tracks mentioned somewhere. The database is loaded into memory, so it's better with 16 or 32 GB RAM.

Who got 20 million tracks to load?
Logged

zybex

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 2675
Re: Huge database
« Reply #9 on: January 27, 2024, 03:51:23 pm »

https://yabb.jriver.com/interact/index.php/topic,130372.msg904243.html#msg904243

MusicNet test project, so maybe it was 2 million copies of some Phil Collins album  ;D
Logged

eve

  • Citizen of the Universe
  • *****
  • Posts: 689
Re: Huge database
« Reply #10 on: January 27, 2024, 04:13:58 pm »

https://yabb.jriver.com/interact/index.php/topic,130372.msg904243.html#msg904243

MusicNet test project, so maybe it was 2 million copies of some Phil Collins album  ;D

Okay now I'm very curious.

Was going to a pane view and scrolling from 0 to the end possible? Was searching possible?


Logged

EnglishTiger

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 1118
Re: Huge database
« Reply #11 on: January 28, 2024, 01:06:35 am »

Okay now I'm very curious.

Was going to like a pane view and scrolling from 0 to the end possible?

Placing the mouse in the right place before starting to scroll in "panes view" makes scrolling through a library; regardless of the number of albums/tracks; smoother/easier.

For the benefit of anybody wondering where "the right place is" it's hovering the mouse over the scrollbar where there is zero risk of triggering an "on hover event" something that is bound to happen if the mouse is anywhere else in the window when scrolling.
Logged
Apple Mac Mini Desktop Computer with M4 Pro chip with 12 core CPU and 16 core GPU: 24GB Unified Memory, 512GB SSD Storage, Gigabit Ethernet, 3 Thunderbolt5 + 2USBC ports.

eve

  • Citizen of the Universe
  • *****
  • Posts: 689
Re: Huge database
« Reply #12 on: January 28, 2024, 05:10:58 pm »

Placing the mouse in the right place before starting to scroll in "panes view" makes scrolling through a library; regardless of the number of albums/tracks; smoother/easier.

For the benefit of anybody wondering where "the right place is" it's hovering the mouse over the scrollbar where there is zero risk of triggering an "on hover event" something that is bound to happen if the mouse is anywhere else in the window when scrolling.

Not sure what you mean by this. My question is, was navigating / viewing 20 million track entities doable in a single view?
Logged
Pages: [1]   Go Up