currently Locate implements a sequential search on all records.
This is very slow, is it possible to implement a more performant algorithm?
Thanks
There can't be a more performant algorithm without some prior indexing feature. Ideally you should filter/locate your records directly from the database.
Locate should be slow on a too big table, I wonder how many records you have?