JeffreyGaydos / music-database-generator

An idea to help organize your music with extra metadata using a SQL Server Database. This repository searches through a folder and gathers metadata already in mp3 files to add to a database
2 stars 1 forks source link

Gather Performance Metrics and Attempt to Improve Performance #36

Closed JeffreyGaydos closed 4 months ago

JeffreyGaydos commented 4 months ago

Once you get past around 1,000 tracks, processing becomes extremely slow (~5 seconds per track). The first couple of inserts are quick, but subsequent inserts are much slower. Determine if this is due to something in C# or SQL and attempt to improve performance.