Storing/ Accessing Large Amounts of Data in Swift

Question

I've got a database with over 200k entries. I want to be able to access the database to determine whether various values exist within that database.

The only thing I can think of to achieve what I'm trying to do, is using an array, but I'm not sure how fast searching through an array will take. Is an array the best way of finding values within a list, or is there something better?

Answer 1

Create a Sqlite db from your excel and create specific query for your needs. I recommend using FMDB for this, its written in Objective-C but there is a description for how to use it in Swift

EDIT:As Gwendal Roué mentioned there is a better alternative using GRDB instead of FMDB