INTERACT FORUM

Please login or register.

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

Author Topic: Huge database  (Read 503 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: 71370
  • 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: 2376
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: 71370
  • 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: 651
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: 651
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: 2376
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: 651
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

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 956
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
Win NUC - VENOEN 11Th NUC Mini PC Core i7 1165G7,Dual HDMI 2.0+Mini DP,Windows 11 Mini Desktop Computer,Thunderbolt 4.0,1 Lan, USB-C,Wifi,Bluetooth 5.0,32GB RAM Toshiba MQ04ABF100 ‎500Gb 5400 RPM ‎eSATA HD, Gigabyte GP-GSM2NE3512GNTD 1Tb NVMe SSD, Samsung 870 QVO 8 TB SATA 2.5 Inch SSD (MZ-77Q8T0) in Sabrent Ultra Slim USB 3.0 to 2.5-Inch SATA External Aluminium Hard Drive Enclosure (EC-UK30)

Apple 2020 Mac mini M1 Chip (8GB RAM, 512GB SSD)
Sabrent Thunderbolt 3 to Dual NVMe M.2 SSD Tool-Free Enclosure with Sabrent 2TB Rocket NVMe PCIe M.2 2280 High Performance SSD + Crucial P3 Plus 4TB M.2 PCIe

ET Skins & TrackInfo Plugins - https://englishtiger.uk/index.html

eve

  • Citizen of the Universe
  • *****
  • Posts: 651
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