channel message text search slow

nextgenhealthcare / connect

The swiss army knife of healthcare integration.

Other

869 stars 265 forks source link

channel message text search slow #6064

Closed ourlang closed 5 months ago

ourlang commented 5 months ago

Searching for a text match takes 30 minutes

Is there any optimization method or is there something wrong with the operation

pacmano1 commented 5 months ago

The way you are searching requires a full table scan. Mirth will search everywhere (source and destinations). So the search time will be impacted by the number of messages you have.

For faster searching, uses metedata columns (see the advanced button). You can also limit dates.

Lastly, your question is not an "issue", it is a something you do not undertand about Mirth. Please do not create issue unless it is confirmed bug.