Faster offline search by GC code

Geraod van Seltenmore shared this idea 3 years ago

One functional way is described by mambofive here: - thank God for it. But it is slow on big database. As I understand it searches whole database "brute force" on all collums. As I expect faster way would be to index the collumn "GC Code" and to implement searching by the new "GC Code" index. Or alternatively to search only the collumn "GC Code" without the index.

Comments (1)


Good day Geraod,

searching for imported caches in Locus by it's GC code is possible and should works quite fast. Search screen offer to enable/disable fulltext search, so with full text disabled, results should be available within few seconds.