I'm compiling a database of decently sized documents (anywhere from 20 to 500 characters), and I would like to be able to very quickly (under 1s) search through them. I started with around 100k rows worth of data, and now…
Are there any additional steps I can take to speed up query execution? I have a table with more than 100m rows and I need to do search for matching strings. For that I checked two options: Compare text with…
My table has 650M rows (according to a fast but decently precise estimate from a query I found here). It has a text column called receiver_account_id, and I need to be able to search those records like: r.receiver_account_id LIKE '%otherWordsHere'.…