title: import heavy excel to mysql using php
body: <p>I am having excel sheet which contains data in something like this ex. if sheet has  "city" and  "person name" columns.So every time we need to check whether the city exists in city table(mysql) or not if not then new row will be  inserted for city in city table similarly will check for person name also if don't exists in person table(mysql) then we need to save person name in person table .
  So what can be the best way to import heavy excel file of  2gb atleast into mysql using php in the above explained scenario so that less queries will be executed with  less load on server and execution will be done in fraction of seconds.
  Kindly suggest me the optimize solution for above scenario.   </p>