Bahmni search by identifier slow (0.88)

[Tip]

We noticed that the Bahmni search by identifier is unusably slow in release 0.88. A typical search on around 50k patients took around 30 seconds. The primary cause of this is the % at the beginning of search in the search sql here

Fix - Either upgrade to 0.89 if you can, or patch the line and remove the prefix % (assuming you don’t need to be able to search with a wildcard prefix).

2 Likes

Is this from registration? We moved to lucene search for identifiers.

Yes Angshu, it was from registration. I think lucene search was introduced in 0.89.