optimizations made: add_index(:cities, :abbreviation) & optimized api call