My site is going full-speed, but I just upgraded to 3.0 and everything's going so slowly. I got a call from my host saying he had to restart his server and shut down and restart apache. Still, everything's slow. Any advice. (For those of you who read this in the future: If you click on the following link and it's not slow, I've fixed it.)
Can you email your gedcom to me? I would like to do some testing on it.
Some things that you can try to help speed it up are:
1. manually edit the gedcom.ged_conf.php file in the index directory and increase the value of teh COMMON_NAMES_THRESHOLD variable so that not so many common names are returned.
2. edit functions_mysql.php and comment out lines 1451-1470. This will prevent the common surnames code from running.
--John
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
219 Names in the Common names list. WOW. And yes it was slow to load the full page. And with the executions stats of Total Execution time: 89.872 sec. Total Database Queries: 175.
I agree with John turn off the stats block.
I ask do you really have 76 Thousand entries? Was this joined with some of the floating Super Gedcom files that are out there?
Have you verified the contents of the gedcom IE did you input this data yourself? If so, how long have you been doing this?
(just wondering)
John
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
You really need to do more than just remove the common surnames block, because the same list of names is calculated and placed in the metatags on every page.
For each of those 219 surnames there were at least 40 names that were pulled from the database that had that surname.
If you get the latest files from the CVS, the configuration options mentioned above, have been added to the online configuration script to make it easier for you to modify them.
--John
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Since the list is used on all pages does it not make sense to calculate this on gedcom import and just add them to their own table or config file? This way bringing it up every page would incure very little overhead? Little would change in the gedcoms between imports that would make the list out of date.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The only problem with calculating it at import time is that you can't change the threshold setting without reimporting.
I also figured that with the new settings you could just copy the list from that page and paste it into the added common names list and set the threshold to a really high number.
--John
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Sorry I didn't respond... sourceforge wasn't sending me notifications that anyone had responded...
And no, this whole file isn't mine. It's mostly my wife's grandparents'. About 1000 are mine, that I've researched, and the other 75K are from her side of the family. Still, they're serious researchers, and the tree isn't too extremely wide, and they're from old-stock families, so I suspect it's mostly correct.
Mine is mostly the role of compiling everything that's been written in pencil and passed down for centuries, typing it in, and publishing it.
Anyway, I emptied the sql and reimported the file, just to see if that helped... it didn't. Still 465 seconds this time!
Now I'll try changing the threshhold. This is odd, when I try to change gedcom.ged_conf.php, it gives me "permission denied." Is that possible? I can edit any other file on my site. So commenting out the lines in functions_mysql won't work, since the gedcom.ged_conf.php is still calling on it.
John F, can I have your email address to email it to? I don't know if my SMTP will allow it, but it's not a big company, so it should. Otherwise you know where it is (www.colinandbethany.com/familyhistory/index/crjensen.ged).
Thanks all.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I apologize for not knowing programming much, but when you say "comment out lines 1451-1470" do you mean put // before each line? And mine's only 1466 lines long. Will you tell me the first few words of 1451 and 1470, so I can figure out which line's which on your file?
I was able to increase the common names threshhold to 100, and now it only shows 13 names, but that didn't do much for load-time.
I downloaded the CVS versions of the editconfig_gedcom and the english language files.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Okay, I figured out which lines to comment out, which takes the Welcome page to 21 seconds and the pedigree is down to 3 seconds. So until we get this down, can I set my main page to be the pedigree, like the old version?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I downloaded your gedcom the other day in hopes to test it against my host. I finally got to test it I've been teaching myself php the last week or so, and can now say I don't know much. Anyhow, your gedcom runs much faster on my host.
Total Execution time: 11.227 sec. Total Database Queries: 242.
Total Execution time: 13.336 sec. Total Database Queries: 33.
Total Execution time: 8.127 sec. Total Database Queries: 40.
I left the pages at default and used the Ocean theme. You can view this by going to www.TrainerFamily.net/phpGedView
When you get there, switch Gedcoms via the menus, and select "crjensen test"
I know my host is running a P4 *nix based machine. Specifics I didn't care at the time.
This is PGV 3.00.1 Non-CVS update at the time of this posting.
Thanks
John
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The one you downloaded shows 39475 Individuals, 0 Families, 0 Sources, 5 Other Records; and the most common surnames are all numbers. So I wonder if the GED corrupted while downloading...
My full ged should be 37.9 M.
Thanks again for your help.
--Colin
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
This might not be related but I had an issue in that when a user was not logged in everything came up fine and when they did login it took more than 30 seconds for the first screen to appear. I found I had to turn off the "Upcoming Events Block" and it came up fine after that. The block was and still is there for those users who are not logged in and works fine. The issue will probably pop up again for the next registered user.
Ron
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
...and it's not just my fat body.
My site is going full-speed, but I just upgraded to 3.0 and everything's going so slowly. I got a call from my host saying he had to restart his server and shut down and restart apache. Still, everything's slow. Any advice. (For those of you who read this in the future: If you click on the following link and it's not slow, I've fixed it.)
http://www.colinandbethany.com/familyhistory/
Hi Colin,
Can you remove the statistics block from the welcome page and see what happens?
It is indeed slow :)
Regards,
Roland
Colin,
Can you email your gedcom to me? I would like to do some testing on it.
Some things that you can try to help speed it up are:
1. manually edit the gedcom.ged_conf.php file in the index directory and increase the value of teh COMMON_NAMES_THRESHOLD variable so that not so many common names are returned.
2. edit functions_mysql.php and comment out lines 1451-1470. This will prevent the common surnames code from running.
--John
219 Names in the Common names list. WOW. And yes it was slow to load the full page. And with the executions stats of Total Execution time: 89.872 sec. Total Database Queries: 175.
I agree with John turn off the stats block.
I ask do you really have 76 Thousand entries? Was this joined with some of the floating Super Gedcom files that are out there?
Have you verified the contents of the gedcom IE did you input this data yourself? If so, how long have you been doing this?
(just wondering)
John
You really need to do more than just remove the common surnames block, because the same list of names is calculated and placed in the metatags on every page.
For each of those 219 surnames there were at least 40 names that were pulled from the database that had that surname.
If you get the latest files from the CVS, the configuration options mentioned above, have been added to the online configuration script to make it easier for you to modify them.
--John
Since the list is used on all pages does it not make sense to calculate this on gedcom import and just add them to their own table or config file? This way bringing it up every page would incure very little overhead? Little would change in the gedcoms between imports that would make the list out of date.
The only problem with calculating it at import time is that you can't change the threshold setting without reimporting.
I also figured that with the new settings you could just copy the list from that page and paste it into the added common names list and set the threshold to a really high number.
--John
Sorry I didn't respond... sourceforge wasn't sending me notifications that anyone had responded...
And no, this whole file isn't mine. It's mostly my wife's grandparents'. About 1000 are mine, that I've researched, and the other 75K are from her side of the family. Still, they're serious researchers, and the tree isn't too extremely wide, and they're from old-stock families, so I suspect it's mostly correct.
Mine is mostly the role of compiling everything that's been written in pencil and passed down for centuries, typing it in, and publishing it.
Anyway, I emptied the sql and reimported the file, just to see if that helped... it didn't. Still 465 seconds this time!
Now I'll try changing the threshhold. This is odd, when I try to change gedcom.ged_conf.php, it gives me "permission denied." Is that possible? I can edit any other file on my site. So commenting out the lines in functions_mysql won't work, since the gedcom.ged_conf.php is still calling on it.
John F, can I have your email address to email it to? I don't know if my SMTP will allow it, but it's not a big company, so it should. Otherwise you know where it is (www.colinandbethany.com/familyhistory/index/crjensen.ged).
Thanks all.
The "permission denied" error is possible, since the file is likely owned by the user that PHP runs as (often user "nobody").
Instead of manually changing the file, you could get the new editconfig_gedcom.php file from the CVS here:
http://cvs.sourceforge.net/viewcvs.py/phpgedview/phpGedView/editconfig_gedcom.php?view=markup
And the necessary language files:
http://cvs.sourceforge.net/viewcvs.py/phpgedview/phpGedView/languages/
Commenting out the lines in functions_mysql.php would also still work.
--John
I apologize for not knowing programming much, but when you say "comment out lines 1451-1470" do you mean put // before each line? And mine's only 1466 lines long. Will you tell me the first few words of 1451 and 1470, so I can figure out which line's which on your file?
I was able to increase the common names threshhold to 100, and now it only shows 13 names, but that didn't do much for load-time.
I downloaded the CVS versions of the editconfig_gedcom and the english language files.
If you look at my source, 'This day in history' also has 115 entries on my welcome page.
Still, I think, if stats were the issue, the pedigree pages would load full-speed.
Okay, I figured out which lines to comment out, which takes the Welcome page to 21 seconds and the pedigree is down to 3 seconds. So until we get this down, can I set my main page to be the pedigree, like the old version?
So how do I
a) get index.php to point towards pedigree.php
or
b) turn off the "this day in history" calculations?
It's just slowing my page down too much.
a) make a copy of pedigree.php and rename it to index.php
b) login as an admin, go index.php and click on the customize link. Then remove the date blocks.
--John
Colin,
I downloaded your gedcom the other day in hopes to test it against my host. I finally got to test it I've been teaching myself php the last week or so, and can now say I don't know much. Anyhow, your gedcom runs much faster on my host.
Total Execution time: 11.227 sec. Total Database Queries: 242.
Total Execution time: 13.336 sec. Total Database Queries: 33.
Total Execution time: 8.127 sec. Total Database Queries: 40.
I left the pages at default and used the Ocean theme. You can view this by going to www.TrainerFamily.net/phpGedView
When you get there, switch Gedcoms via the menus, and select "crjensen test"
I know my host is running a P4 *nix based machine. Specifics I didn't care at the time.
This is PGV 3.00.1 Non-CVS update at the time of this posting.
Thanks
John
Thanks for your help, John.
Well, my old/new welcome page is called index2 now: http://www.colinandbethany.com/familyhistory/index2.php, and it shows 76064 Individuals, 32957 Families, 765 Sources, 13 Other Records.
The one you downloaded shows 39475 Individuals, 0 Families, 0 Sources, 5 Other Records; and the most common surnames are all numbers. So I wonder if the GED corrupted while downloading...
My full ged should be 37.9 M.
Thanks again for your help.
--Colin
Ah I only go 16 MB perhaps the download was truncuated.
It was worth the try.
I've got a similar problem:
site is really slow, but it seems to be the media.
when deleting the random picture block, the index.php is loading much faster.
The medialist.php is impossible to show (webmaster has set php execution time to a maximum of 30s.
You can have a look at
http://ahnen.pluntke.com/script/phpp/index.php
Regards
Peter
PS: This is in INDEX-mode with about 2500 indis and 120 mediafiles.
I've tested same URL in MySQL-Mode (so you can NOT test the above mentioned issue at the moment!!!)
and the medialist issue seems to be gone.
Though all pages are still too slow.... (about 23 seconds for a pedigree chart)
Peter
Hi Guys,
This might not be related but I had an issue in that when a user was not logged in everything came up fine and when they did login it took more than 30 seconds for the first screen to appear. I found I had to turn off the "Upcoming Events Block" and it came up fine after that. The block was and still is there for those users who are not logged in and works fine. The issue will probably pop up again for the next registered user.
Ron