Re: 1346: Optimize database (Complete) Never Ends
Posted: Sat Feb 05, 2011 7:42 am
I gave it a try my database is 570mb big and its been running now for about 6 hours and still counting
The Music Manager for Serious Collectors
http://mediamonkey.com/forum/
And what SQL do you see in DbgView ?robojock wrote:I gave it a try my database is 570mb big and its been running now for about 6 hours and still counting
Code: Select all
[1376] 3188 DB open SQL: SELECT WebCommercial, WebCopyright, WebFilepage, WebArtist, WebSource, WebRadio, WebPayment, WebPublisher, WebUser, PreviewStartTime, PreviewLength, CacheName, PreviewName, Copyright, Encoder, ISRC, InitialKey, Language, OrigLyricist, ParentalRating,PreGap, PostGap, TotalSamples, GaplessBytes, SignType, SignPart1, SignPart2, SignPart3, SignPart4, ContainerType, StreamCount, StreamInfo FROM Songs WHERE ID = 10
[1376] 3188 DB lock finished, took 627714.
[1376] 3188 DB exec SQL: INSERT INTO SongsText (rowid,artist,album,albumartist,songtitle,genre,songpath,author,lyricist,conductor,groupdesc,subtitle,lyrics,comment,custom1,custom2,custom3,custom4,custom5,origartist,origtitle,origlyricist,publisher,encoder,copyright,mood,tempo,occasion,quality,involvedpeople) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
[1376] 3188 DB lock successful.
[1376] 3188 DB lock finished, took 97554533.