We're ready to move to sql from index on our phpGedView gedcom db, running on our dual 1.25 G4 now that it is installed and prefs set.
NE thing we should know? Will we lose the registered users if we activate the sql files instead of index? What suggestions does someone who's done this have. Will the program response be faster?
Thanks, Stephen
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
When you switch to mysql you will lose your registered users. But, all of your users are stored in a PHP array in the authenticate.php file. Depending on how many users you have, you could open this file in a text editor and manually enter the data into the MySQL table using something like PhpMyAdmin.
If you have any major problems you can switch back to index mode and you shouldn't lose anything. Eventually you will want to clean out your index directory and remove all of the _index.php files and the authenticate.php file.
The performance increase you will see will depend on the size of your gedcom. With smaller gedcoms (<1MB), the index mode will outperform MySQL, but with larger gedcoms (>1MB) MySQL will outperform.
--John
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
John:
Thanks. Moved all the users and tested their access.
New DB still testing, but appears about 50-75% (or more) faster response and screen refresh. WOW! Who'd a thunk it? After a burn-in, we'll swap out the folders so the sql version is serving by default.
We're ready to move to sql from index on our phpGedView gedcom db, running on our dual 1.25 G4 now that it is installed and prefs set.
NE thing we should know? Will we lose the registered users if we activate the sql files instead of index? What suggestions does someone who's done this have. Will the program response be faster?
Thanks, Stephen
Stephen,
When you switch to mysql you will lose your registered users. But, all of your users are stored in a PHP array in the authenticate.php file. Depending on how many users you have, you could open this file in a text editor and manually enter the data into the MySQL table using something like PhpMyAdmin.
If you have any major problems you can switch back to index mode and you shouldn't lose anything. Eventually you will want to clean out your index directory and remove all of the _index.php files and the authenticate.php file.
The performance increase you will see will depend on the size of your gedcom. With smaller gedcoms (<1MB), the index mode will outperform MySQL, but with larger gedcoms (>1MB) MySQL will outperform.
--John
John:
Thanks. Moved all the users and tested their access.
New DB still testing, but appears about 50-75% (or more) faster response and screen refresh. WOW! Who'd a thunk it? After a burn-in, we'll swap out the folders so the sql version is serving by default.
testing at: http://ot.no-ip.org/rootsql/
Stephen