Ingreso rápido:  

Forum: VirtualDJ Technical Support

Tema: Really very slow database

Este tópico es antiguo y puede contener información incorrecta para la nueva versión.

Is it just me and my computers, or are both my rigs with big music collection affected with crashing harddrives these days? Takes 5-10min to browse into big folders these days ... Hmm...
 
Mensajes Sat 27 Jun 20 @ 10:52 am

Do you have file date on as a column by any chance ?
(that is not part of the database and needs the OS to report that, for each and every file, and can be slower)

Alternatively external drive that falls asleep when not in use, and takes a few to wake up?
 
Mensajes Sat 27 Jun 20 @ 10:57 am
No, just default.



No disk is allowed to sleep, that is the first thing I disable when I install windows. But here it takes 5-10min just to enter a folder some times. Have no usb disk connected either.
 
Mensajes Sat 27 Jun 20 @ 11:03 am
How big is "big"?
 
Mensajes Sat 27 Jun 20 @ 11:04 am
groovindj wrote :
How big is "big"?


8 TB
 
Mensajes Sat 27 Jun 20 @ 11:08 am
RoninSaniShipibo wrote :
No, just default..


Its almost 150.000 files in that folder. Did you do a recurse since its show that many? (Aka parent folder, and all its subfolders..)


But if it takes 5 minutes to open, maybe your drive is starting to fail...
Try this, open same folder (wait a while first), with Windows Explorer. Is it equally slow to open up?

 
Mensajes Sat 27 Jun 20 @ 11:10 am
But I had to shut down one computer yesterday, and use my backup. And today my backup stopped browsing, I restarted after 10min, could not wait forever... Something is fed up but I dont know what yet.
 
Mensajes Sat 27 Jun 20 @ 11:11 am

Is it literally 10 minutes ? or you say "10 minutes" as an expression of being slow (taking longer than instant, a 10 seconds or something)

If its literally 10 minutes, then your drive might be starting to fail.
After PC has been idle for a while, try open same folder with Windows Explorer and see if its also very slow
 
Mensajes Sat 27 Jun 20 @ 11:13 am
Rune (dj-in-norway) wrote :
RoninSaniShipibo wrote :
No, just default..


Its almost 150.000 files in that folder. Did you do a recurse since its show that many? (Aka parent folder, and all its subfolders..)


But if it takes 5 minutes to open, maybe your drive is starting to fail...
Try this, open same folder (wait a while first), with Windows Explorer. Is it equally slow to open up?



What is a recurse? think I have some idea... but I have used this music collection for many many years. There is about 500.000 total, and the filter folder with subfolder takes usually 30 sec to load. But I never open complete music collection with filter folder any more. But yesterday it takes forever to just browse into regular folders. And it happened to both my main computer and my backup the same time. But now, it works again..... ripping my hair if this problem comes back.
 
Mensajes Sat 27 Jun 20 @ 11:20 am
I will check my disk after i have got a new one and cloned to. I just wanted to see if anyone else had big trouble with database and browsing now.

Edit: yes, 10min means 10min++ till i cant wait anymore and restart...
 
Mensajes Sat 27 Jun 20 @ 11:22 am
RoninSaniShipibo wrote :

Edit: yes, 10min means 10min++ till i cant wait anymore and restart...


Probably something with your computer then. Would check if its same in Windows Explorer (possibly corrupted drive allocation table, or drive starting to fail)
 
Mensajes Sat 27 Jun 20 @ 11:30 am
I assume you're using standard "old fashioned" mechanical hard drives. Maybe you should consider SSD.
 
Mensajes Sat 27 Jun 20 @ 11:32 am
Rune (dj-in-norway) wrote :
RoninSaniShipibo wrote :

Edit: yes, 10min means 10min++ till i cant wait anymore and restart...


Probably something with your computer then. Would check if its same in Windows Explorer (possibly corrupted drive allocation table, or drive starting to fail)





That is driving me insane. I can list directories with windows atm(fast) but with virtual dj it suddenly takes forever. But suddenly I cant find a glimp now, all works like a charm. Loading 500.000 files with filter folder in like ~1min . I think its the heatwave in norway now... I will figure it out with some time.. . thanks a lot Rune. <3
 
Mensajes Sat 27 Jun 20 @ 11:47 am

During the time VirtuaDJ opens this 150.000 song folder, is there anything right above the browser (status field) saying anything?
Like "reading tag..." or any indication of something going on ?
 
Mensajes Sat 27 Jun 20 @ 11:50 am
Rune (dj-in-norway) wrote :

During the time VirtuaDJ opens this 150.000 song folder, is there anything right above the browser (status field) saying anything?
Like "reading tag..." or any indication of something going on ?


No, its just saying "browsing"
 
Mensajes Sat 27 Jun 20 @ 11:54 am
could it be that bitrate column causing the issue i'm sure thats not default
 
Mensajes Sat 27 Jun 20 @ 4:52 pm
I dont think the bitrate is read live (like the date). That would be stored in the database when tracks are analysed.
 
Mensajes Sat 27 Jun 20 @ 4:54 pm


(Los tópicos y foros antiguos son automáticamente cerrados)