Anmelden:     

Forum: VirtualDJ Technical Support

Topic: Slow Search At Random Times
So, following on from 2015s VDJ 8 Posts, This search issue is still a thing, on the latest hardware, and it isn't always a thing, it happens completely randomly. However we are on the very latest version of VDJ. So how is this still an issue? Minutes of wait time as we have 100,000 + Songs from decades of DJ History
 
geposted Sat 20 Jun 26 @ 6:49 pm
turn file date field off, use first seen
 
Suggested in the old posts. Need File Date, We can't use First Seen.
 
Why do you need "date modified" ?
 
becuase there are many copies of songs from decades worth of gathering music, that files have so many date modified fields for the same song
 
Just curious (correct me if there is a misunderstanding)...how do u have many file entries with date modified fields for the same song? You keep duplicates of the same song?

Reason that was asked: Most people keep a single version best version of the song they could find to not have duplicates/minimize space usage, and if they get a better copy they immediately delete the older, worse copy.

The file date/modified field can be used to get that, but it should not be kept on, because in order to always be accurate, the application has to reread metadata from the file itself everytime it is encountered in the browser, to make sure it's up to date (a costly I/O operation, that is multiplied by the many tracks persons have in their library).
 
Decades of music build up. Different Mixes and versions of the same song never had a chance to get to deleting bad copies; not all of them get brought up. During live runs, they get left in the background and are never deleted.
 
Quite simply you need to take the time to curate your database.

Bit like saying you can't see the flowers in your garden for the 6 foot weeds.
 
Yeah, thats going to take a while and there isn't enough time between other things going on in life
 
If you don't service your car it breaks down.
 
We plan to go through it, but it is still decades of music, karaoke and videos.
 
Either way, this is still an app issue, not a user issue. Numark Cue worked perfectly fine to search the songs
 
Still no update on this?
 
Mitchell Stamp wrote :
Suggested in the old posts. Need File Date, We can't use First Seen.


You were told of a solution but you didn't listen, so at this point it is a user issue.
 
Download a tag-editing program, scan all the files overnight, and use the file creation date to populate a tag field you don’t need (I chose Composer).

Then reload all the tags in VirtualDJ, and voilà! Sort by the Composer tag, and your files will be in chronological order by creation date.
 
That's not a correct solution either.

VirtualDJ is slow when it shows any file date because it has to query each file every single time for it's dates.
You see the dates do NOT remain constant to be written/stored in the database.

So, the answer is really simple. If you absolutely need the date fields, then you have to cope with slower times. There's no work around, and no other way since the user says that "first seen" database field is not suitable for him.

Also, @OP when was the last time you have used "Numark Cue" and how many files did you had at that time ?

If I have a database of 1000 songs and I try to search it, even with file dates visible, the search will be fast because at the WORST case VirtualDJ will have to read on the fly the dates of 1000 songs.
If I have a database of 100.000 songs, VirtualDJ could easily be brought to a situation that would need to try to read the dates of half of those files.. Now the difference between reading 1000 and 50.000 file dates is significant, and you don't need to have studied computer science to understand that!
 
Isn't a one time written value in the tag field "composer" constant in the database?
 
@hawkeye filedate is modified date, not created date
 
PhantomDeeJay, we were using Cue up until about a year ago; only a small number of songs have been added to the library since then.