|
Computer Audio Asylum Music servers and other computer based digital audio technologies. |
|
|
|
Computer Audio Asylum Music servers and other computer based digital audio technologies. |
|
In Reply to: RE: It appears posted by rivervalley817 on October 5, 2020 at 11:29:04:
Here's the query from my database to find the path to a unique copy of every music file on any of my drives:
------------------------------------------------------
;
with deduped as (select basename, min(id) as rowid from [FileInventory].[dbo].[f4] group by basename)
select allfiles.* from [FileInventory].[dbo].[f4] allfiles inner join deduped on allfiles.id = deduped.rowid
------------------------------------------------------
and here are the results of running that query to get the path to a unique copy of each music file. Looks like about 3/4 of a second to dedup 80K+ music file records. So about 30K actual files when deduped, out of almost 80K physical files in the various drives.
-------------------------------------------------------
(30296 rows affected)
SQL Server Execution Times:
CPU time = 328 ms, elapsed time = 788 ms.
This post is made possible by the generous support of people like you and our sponsors:
Follow Ups
- RE: It appears - LtMandella 13:05:52 10/05/20 (2)
- RE: It appears - rivervalley817 14:30:13 10/05/20 (1)
- RE: It appears - LtMandella 07:52:03 10/07/20 (0)
Top of Page ]
[ Contact Us ]
[ Support/Wish List ]
[ Copyright © 2024, Audio Asylum, all rights reserved ]
