jan, 15 days ago

@maartenballiauw I would try https://learn.microsoft.com/en-us/sql/relational-databases/search/full-text-search?view=sql-server-ver16 it works fine and it's fast.

khalidabuhakmeh, 15 days ago

@jan @maartenballiauw You win a prize! That’s the answer Maarten was fishing for. 😅

Wicked Tuna Fishing GIF by National Geographic Channel

maartenballiauw, 15 days ago

@khalidabuhakmeh @jan Am I this transparent? :D

khalidabuhakmeh, 15 days ago

@maartenballiauw @jan Select * from Obvious

khalidabuhakmeh, 15 days ago

@maartenballiauw Can I do anything to solve the issue?

maartenballiauw, 15 days ago

@khalidabuhakmeh Anything. What would be your first attempt to improve it?

khalidabuhakmeh, 15 days ago

@maartenballiauw Honestly, I wouldn’t mess around with anything but a proper search engine like ElasticSearch or Azure Search in your case.

While it can “sorta work” within database search indexes, the control over how search occurs is limited.

I’d just rewrite the endpoint (since 60K is nothing to ES).

b4ux1t3, 15 days ago

@khalidabuhakmeh @maartenballiauw This is why I recommended just sticking it in a traditional search/index structure. 60k is so few records that, if I don't expect it to grow that much in the future, I wouldn't even lean on ES. I'd spend more time configuring ES than implementing a custom search index. Heh.

khalidabuhakmeh, 15 days ago

@b4ux1t3 @maartenballiauw Please elaborate by what you mean “traditional search/index” structure.

Is this SQL Server full-text search, or PostgreSQL full text search?

maartenballiauw, 15 days ago

@b4ux1t3 @khalidabuhakmeh Let's say the records don't grow or change that often. Would that change your approach?

khalidabuhakmeh, 15 days ago

@maartenballiauw @b4ux1t3 🤪 Then I have a crazy idea for you, buddy!

Build and deploy a SQLite database with all the records and Full-Text Search at deployment time, and then use that. No extra service costs.

https://www.pythonlore.com/advanced-sqlite3-full-text-search-implementation/

b4ux1t3, 13 days ago

@khalidabuhakmeh @maartenballiauw SQLite is cheating, it does what I was telling you to do without any actual work >:(

(so many problems solved with SQLite)

khalidabuhakmeh, 13 days ago

@b4ux1t3 @maartenballiauw

Sorry GIF