I have started using pane views with nested list fields and it takes a very long time to open such views. I have one view which takes 1 min. 20 sec. to load. To show the sublevel for one item in the pane takes 3-4 sec.
To open a pane view without nested list fields takes 9-10 sec. with 8 panes all set to a database field (i.e. no expressions directly in the panes). The database fields contains mostly expressions sometimes with a lot of If() functions, for example. Grouping is using a calculated field with this expression:
Clean(If(IsEmpty([Date]),Okänt år,FormatDate([Date, 0], Year)) - [Album] If(IsEqual([Genre],Live,7),/[Live/] ,)If(IsEqual([Genre],Compilation,7), /[Comp./] ,)If(IsEqual([Genre],Soundtrack,7), /[Soundtrack/] ,)If(IsEmpty([Album Rating]),, Left(* * * * * ,Math(Left([Album Rating],1)+Left([Album Rating],1)))If(IsEqual(Mid([Album Rating,0],2),5,2),° ,))/(If(IsEqual([iTunes Compilation],1),Blandade artister,If(IsEqual([Compilation],1),Blandade artister,If(IsEmpty([Albumartist]),[album artist (auto)],[Albumartist])))/)
The columns in the views are not calculated but set to a database field.
The database contains 115k files, all are music files and displayed in the initial view. Only two fields (lyrics and reviews) contain larger chunks of text and those are not default search fields or shown in the columns.
I am running a rather powerful PC (JRMark (version 15.0.73): 2132) and was expecting better performance than this even with calculated fields.
I have read this thread and was wondering if someone had any other idea for speeding things up (apart from not making excessive use of nested list fields and fields calculated with complex expressions...).
The 0.5 sec. for a 250k library mentioned earlier in this thread sounds promising, but is not something I have ever experienced.