I am having tables with 2000 records (table1); I need to check the duplicates of records from table2 with 100 records on the basis of User Email address and User Phone number.
Application in cakephp 1.3
Table 1 and Table 2 have same structure-
id, First Name, Last Name, Email, Street, Area, Locality, Country, Postal Code, Phone Number, Hobbies.
I imported data in mysql database with php excel reader and data store properly with more than 2000 records in Table 1. After then I check the duplicates. If Table 1 data is matched with Table 2 with columns "email and phone number", then duplicate entry and duplicate flag enabled in Table 1 and record should not store in Table 2; All the process goes fine but after 853 records application stop I also tried with Maximum Execution Time - 120 seconds. then my application stops after matching 1453 records.
Fatal error: Maximum execution time of 60 seconds exceeded in C:\wamp\www\filepath\cake\libs\model\datasources\dbo\dbo_mysql.php on line 213
I am facing this error. Any one knows the best way to resolve this issue?