Speed-up MySQL version

Brought to you by: canajun2eh, yalnifj

Speed-up MySQL version

Forum: Open Discussion

Creator: Boudewijn Sjouke

Created: 2003-07-05

Updated: 2003-07-07

Boudewijn Sjouke - 2003-07-05

In the MySQL version it takes about 40 seconds to build the persons-list (3000 individuals). After adding indexes om i_name and i_id for the individuals table in the database, that time was brought down to a spectacular 3.6 seconds! To make this permanent, you can add the appropriate statements in the importgedcom.php, just after the statements for creating the tables.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- John Finlay - 2003-07-07
  
  That is a great tip!!
  
  Thanks,
  --John
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.