My CAML Query on a large Pages library based on a folder structure takes too long (15-20 seconds), and I wonder how I could optimize this. I currently use a filter where
FileRef BeginsWith [specific path with subfolders]
FileRef an indexed column by default or not? Would
EncodedAbsUrl be a better option than
I realize that I would be better off if I used a
Choice column and an
Equals filter instead, but a folder structure still seems to be easier to understand for our end users, compared to tagging each item.