Is it better to download a small table (about 3500 records) to an array to look-up something, or create sql commands to look-up the value?
I have a table with station numbers and corresponding links. I am converting an older table that just has the station number. I need to look up the old station number and find the new link before I convert the record. I wondered if it was better to create an array and download the table, or just create sql commands to find the corresponding link.