Some Before and after stats. You can see some serious improvements here.
Loading Movie Base View - Beta 1
Code:
10:10:25 T:344 M:3993485312 DEBUG: CGUIMediaWindow::GetDirectory (videodb://1/2/)
10:10:25 T:344 M:3993485312 DEBUG: ParentPath = [videodb://1/2/]
10:10:25 T:344 M:3993378816 DEBUG: CVideoDatabase::GetSetsNav query: select sets.idSet,sets.strSet,count(1),count(files.playCount) from sets join setlinkmovie on sets.idSet=setlinkmovie.idSet join movie on setlinkmovie.idMovie=movie.idMovie join files on files.idFile=movie.idFile group by sets.idSet
10:10:25 T:344 M:3993251840 DEBUG: CVideoDatabase::GetMoviesByWhere query: select * from movieview where movieview.idmovie NOT in (select idmovie from setlinkmovie)
10:10:25 T:344 M:3976679424 DEBUG: Time for actual SQL query = 150
10:10:26 T:344 M:3957030912 DEBUG: Time to retrieve movies from dataset = 1561
10:10:27 T:344 M:3969323008 DEBUG: Saving fileitems [videodb://1/2/]
10:10:27 T:344 M:3964686336 DEBUG: -- items: 2161, sort method: 23, ascending: true
Loading Movie Base View - Rev25083
Code:
08:47:27 T:3156 M:3315920896 DEBUG: CGUIMediaWindow::GetDirectory (videodb://1/2/)
08:47:27 T:3156 M:3315920896 DEBUG: ParentPath = [videodb://1/2/]
08:47:27 T:3156 M:3315806208 DEBUG: CVideoDatabase::GetSetsNav query: select sets.idSet,sets.strSet,count(1),count(files.playCount) from sets join setlinkmovie on sets.idSet=setlinkmovie.idSet join movie on setlinkmovie.idMovie=movie.idMovie join files on files.idFile=movie.idFile group by sets.idSet
08:47:27 T:3156 M:3315687424 DEBUG: CVideoDatabase::GetMoviesByWhere query: select * from movieview where movieview.idmovie NOT in (select idmovie from setlinkmovie)
08:47:27 T:3156 M:3299229696 DEBUG: Time for actual SQL query = 73
08:47:28 T:3156 M:3279396864 DEBUG: Time to retrieve movies from dataset = 985
08:47:29 T:3156 M:3291701248 DEBUG: Saving fileitems [videodb://1/2/]
08:47:29 T:3156 M:3286880256 DEBUG: -- items: 2161, sort method: 23, ascending: true
Loading TV View - Beta 1
Code:
10:10:32 T:344 M:3972214784 DEBUG: CGUIMediaWindow::GetDirectory (videodb://2/2/)
10:10:32 T:344 M:3972214784 DEBUG: ParentPath = [videodb://2/2/]
10:10:32 T:344 M:3972214784 DEBUG: CVideoDatabase::GetTvShowsByWhere query: select * from tvshowview
10:10:33 T:344 M:3948441600 DEBUG: Time for actual SQL query = 1089
10:10:41 T:344 M:3948167168 DEBUG: Time to retrieve movies from dataset = 7892
10:10:41 T:344 M:3965681664 DEBUG: Saving fileitems [videodb://2/2/]
10:10:41 T:344 M:3963228160 DEBUG: -- items: 1017, sort method: 2, ascending: true
Loading TV View - Rev25083
Code:
08:47:33 T:3156 M:3291283456 DEBUG: CGUIMediaWindow::GetDirectory (videodb://2/2/)
08:47:33 T:3156 M:3291283456 DEBUG: ParentPath = [videodb://2/2/]
08:47:33 T:3156 M:3291484160 DEBUG: CVideoDatabase::GetTvShowsByWhere query: select * from tvshowview
08:47:33 T:3156 M:3267399680 DEBUG: Time for actual SQL query = 550
08:47:33 T:3156 M:3267194880 DEBUG: Time to retrieve tvshows from dataset = 313
08:47:34 T:3156 M:3285377024 DEBUG: Saving fileitems [videodb://2/2/]
08:47:34 T:3156 M:3282980864 DEBUG: -- items: 1017, sort method: 2, ascending: true