Maarten Balliauw on Nostr: Experiment... As the "search engine" behind a 5000-records auto complete API is an ...
Experiment... As the "search engine" behind a 5000-records auto complete API is an #efcore LIKE query. Loading 60000 more records into that table made the API endpoint slow (6 seconds to show autocomplete!)
How would you improve this autocomplete? #dotnet
Published at
2024-05-13 12:01:53 UTCEvent JSON
{
"id": "1a5bb4bb67464b16ad9ac0aad2c033161e1bfbed70b47f9366e46bf46f789f64",
"pubkey": "73bc9bdca25bfec31f86b08548aa1fd2e258fc03e58ccaa94e4c1910cfe6e6b1",
"created_at": 1715601713,
"kind": 1,
"tags": [
[
"t",
"efcore"
],
[
"t",
"dotnet"
],
[
"proxy",
"https://mastodon.online/users/maartenballiauw/statuses/112433673894247648",
"activitypub"
]
],
"content": "Experiment... As the \"search engine\" behind a 5000-records auto complete API is an #efcore LIKE query. Loading 60000 more records into that table made the API endpoint slow (6 seconds to show autocomplete!)\n\nHow would you improve this autocomplete? #dotnet",
"sig": "36f557d79a15071802ef1aa574dafffa0cb159f2e23bea744ebf7786213e9b8485ae2573d7d333ac166a4a7f9f2543d5faf11ac72f42c8f3a54ce5f4430f55b6"
}
