I've built a basic search engine that search various CIMY fields and returns a set of users. I'm using the CIMY provided 'get' statements to partially match my search term against a number of fields. If they term is partially matched in any, the user is included in my results.
My question, is this a performant way of doing things? I'm current searching 1000 users, and the my search code takes a while (5-6 seconds) to execute. This is probably down to my down code.. but I wondered if the 'Get' statements scale well when used like this? Or should I consider searching the database directly?