I'm going to build a Go application that will check id(s) in a list of ids. Structure will be something like this for database:
Company A
--
List 1 -> 100.000 ids
List 2 -> 250.000 ids
Company B
--
List 1 -> 100.000 ids
List 2 -> 250.000 ids
etc..
These ids will be strings and I need to efficently query multiple ids and get which are those exists in the collection. Write operation will be only once for each list so write performance isn't really important but read should be fast. What would be the best database solution for this on?
Asked by Svnd
(1 rep)
Jan 19, 2023, 02:00 PM
Last activity: Jan 20, 2023, 09:25 AM
Last activity: Jan 20, 2023, 09:25 AM