Hey guys!
I’m looking for ideas for a solution to my problem. I have a “Item” table with lots of rows (~500k) and I need to search it on a string field.
The first time I search (in some view, trying to link an item with another object) it takes ages to return a result, but afterwards the performance is totally adequate. Is there a way to force that initial preload once I open the document, so that I don’t get that sluggish first search?