Re: [SlimDevices: Beta] 7.9 - help me to better understand database andindex usage

Fri, 16 May 2014 04:16:13 -0700 

Code:
--------------------
    [14-05-16 07:08:07.4697] Slim::Schema::optimizeDB (433)             
albumsArtworkIndex: 2280 2
  [14-05-16 07:08:07.4700] Slim::Schema::optimizeDB (433)           
albumsDiscCountIndex: 2280 326
  [14-05-16 07:08:07.4702] Slim::Schema::optimizeDB (433)                
albumsDiscIndex: 2280 326
  [14-05-16 07:08:07.4705] Slim::Schema::optimizeDB (433)                
albumsYearIndex: 2280 36
  [14-05-16 07:08:07.4707] Slim::Schema::optimizeDB (433)           
compilationSortIndex: 2280 760
  [14-05-16 07:08:07.4710] Slim::Schema::optimizeDB (433)        
albumsCustomSearchIndex: 2280 2280
  [14-05-16 07:08:07.4712] Slim::Schema::optimizeDB (433)              
albumsSearchIndex: 2280 2
  [14-05-16 07:08:07.4715] Slim::Schema::optimizeDB (433)                
albumsSortIndex: 2280 2
  [14-05-16 07:08:07.4718] Slim::Schema::optimizeDB (433)               
albumsTitleIndex: 2280 2
  [14-05-16 07:08:07.4720] Slim::Schema::optimizeDB (433)            
comments_trackIndex: 12333 2
  [14-05-16 07:08:07.4723] Slim::Schema::optimizeDB (433)     
contributor_albumRoleIndex: 4317 864
  [14-05-16 07:08:07.4725] Slim::Schema::optimizeDB (433)    
contributor_albumAlbumIndex: 4317 2
  [14-05-16 07:08:07.4728] Slim::Schema::optimizeDB (433)  
contributor_albumContribIndex: 4317 2
  [14-05-16 07:08:07.4730] Slim::Schema::optimizeDB (433)     
contributor_trackRoleIndex: 31398 6280
  [14-05-16 07:08:07.4733] Slim::Schema::optimizeDB (433)    
contributor_trackTrackIndex: 31398 2
  [14-05-16 07:08:07.4735] Slim::Schema::optimizeDB (433)  
contributor_trackContribIndex: 31398 14
  [14-05-16 07:08:07.4738] Slim::Schema::optimizeDB (433)  
contributorsCustomSearchIndex: 2266 2266
  [14-05-16 07:08:07.4740] Slim::Schema::optimizeDB (433)        
contributorsSearchIndex: 2266 2
  [14-05-16 07:08:07.4743] Slim::Schema::optimizeDB (433)          
contributorsSortIndex: 2266 2
  [14-05-16 07:08:07.4746] Slim::Schema::optimizeDB (433)          
contributorsNameIndex: 2266 1
  [14-05-16 07:08:07.4748] Slim::Schema::optimizeDB (433)          
genre_trackTrackIndex: 26260 1
  [14-05-16 07:08:07.4751] Slim::Schema::optimizeDB (433)          
genre_trackGenreIndex: 26260 248
  [14-05-16 07:08:07.4753] Slim::Schema::optimizeDB (433)         
genreCustomSearchIndex: 106 106
  [14-05-16 07:08:07.4756] Slim::Schema::optimizeDB (433)               
genreSearchIndex: 106 2
  [14-05-16 07:08:07.4758] Slim::Schema::optimizeDB (433)                 
genreSortIndex: 106 2
  [14-05-16 07:08:07.4760] Slim::Schema::optimizeDB (433)                 
genreNameIndex: 106 1
  [14-05-16 07:08:07.4761] Slim::Schema::optimizeDB (433)                  
playlistIndex: 2 2
  [14-05-16 07:08:07.4763] Slim::Schema::optimizeDB (433)                  
positionIndex: 2 1
  [14-05-16 07:08:07.4765] Slim::Schema::optimizeDB (433)                
scannedUrlIndex: 28882 1
  [14-05-16 07:08:07.4767] Slim::Schema::optimizeDB (433)                 
trackHashIndex: 26278 26278
  [14-05-16 07:08:07.4768] Slim::Schema::optimizeDB (433)                   
coveridIndex: 26278 7
  [14-05-16 07:08:07.4770] Slim::Schema::optimizeDB (433)                    
urlmd5Index: 26278 1
  [14-05-16 07:08:07.4772] Slim::Schema::optimizeDB (433)                     
trackExtId: 26278 26278
  [14-05-16 07:08:07.4774] Slim::Schema::optimizeDB (433)                       
urlIndex: 26278 1
  [14-05-16 07:08:07.4775] Slim::Schema::optimizeDB (433)             
trackLosslessIndex: 26278 8760
  [14-05-16 07:08:07.4777] Slim::Schema::optimizeDB (433)               
trackRemoteIndex: 26278 26278
  [14-05-16 07:08:07.4779] Slim::Schema::optimizeDB (433)               
trackLyricsIndex: 26278 1011
  [14-05-16 07:08:07.4780] Slim::Schema::optimizeDB (433)                
trackAudioIndex: 26278 8760
  [14-05-16 07:08:07.4782] Slim::Schema::optimizeDB (433)             
trackTracknumIndex: 26278 321
  [14-05-16 07:08:07.4784] Slim::Schema::optimizeDB (433)            
trackTimestampIndex: 26278 4
  [14-05-16 07:08:07.4785] Slim::Schema::optimizeDB (433)             
trackFilesizeIndex: 26278 2
  [14-05-16 07:08:07.4787] Slim::Schema::optimizeDB (433)                 
trackDiscIndex: 26278 3285
  [14-05-16 07:08:07.4789] Slim::Schema::optimizeDB (433)              
trackBitrateIndex: 26278 9
  [14-05-16 07:08:07.4790] Slim::Schema::optimizeDB (433)         
trackCustomSearchIndex: 26278 26278
  [14-05-16 07:08:07.4792] Slim::Schema::optimizeDB (433)               
trackSearchIndex: 26278 2
  [14-05-16 07:08:07.4794] Slim::Schema::optimizeDB (433)                 
trackSortIndex: 26278 2
  [14-05-16 07:08:07.4795] Slim::Schema::optimizeDB (433)                    
ctSortIndex: 26278 3285
  [14-05-16 07:08:07.4797] Slim::Schema::optimizeDB (433)                
trackAlbumIndex: 26278 12
  [14-05-16 07:08:07.4799] Slim::Schema::optimizeDB (433)                
trackTitleIndex: 26278 2
  
--------------------



Ralphy

*1*-Touch, *4*-Classics, *2*-Booms, *1*-Reverted UE Radio
*1*-Squeezeslave, *2*-Squeezeplays, *5*-Squeezelites
'Squeezeslave' (http://code.google.com/p/squeezeslave/) 'donations'
(https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=LL5P6365KQEXN&lc=CA&item_name=Squeezeslave&currency_code=USD&bn=PP%2dDonationsBF%3abtn_donate_SM%2egif%3aNonHosted)
always appreciated.
------------------------------------------------------------------------
ralphy's Profile: http://forums.slimdevices.com/member.php?userid=3484
View this thread: http://forums.slimdevices.com/showthread.php?t=101558

_______________________________________________
beta mailing list
beta@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/beta

Reply via email to