#1287 SVN862 ... so slow

[Mark Hattam]

I've just clicked on a placename on my latest (SVN862) test site on my home PC running XPPro, Apache 2.2.4, PHP 5.2.1, MySQL 5.0.27 ... it's a 2.4 GHz Core2Duo with 2 GB RAM etc etc ... with nothing else running ...

Execution time: 290.779 sec
Total database queries: 11301
Total privacy checks: 38009
Total Memory usage: 55924.13 kb

I left IE7 running long enough to actually finish rendering the page ... a long time !! ... Task Manager says it's currently using 412,200 k of Mem usage, with 157,714 Handles & 11 threads. While rendering the page IE7 was using 50% of total cpu usage, ie one core completely.

OK, the placename is a fairly common one in my gedcom, 1045 families reference it, 5027 Individuals, and 97 place connections.

In PGV 3.3.9, the same placename listing takes
Execution time: 0.189 sec
Total database queries: 9
Total privacy checks: 0
Total Memory usage: 6962.72 kb

That is of course without the families & individuals listed, just the place connections.

If i then click the link for showing individuals & families, that then gives
Execution time: 39.691 sec
Total database queries: 14840
Total privacy checks: 8102
Total memory usage: 21432.18 kb

and this instance of IE7 is just using 46,216 k of memory & 489 handles, 12 threads.

Taking 5 minutes to execute one page is far far too long. I don't know how long IE7 took to actually finish rendering the page, but it was far longer than that.

The database queries don't seem to be the bottleneck, PGV 339 actually did more. But 4.1svn862 (and pretty much anything else 4.1) seems to be doing far too much of something.

Mark

[Greg Roach]

Logged In: YES
user_id=1466942
Originator: NO

I've made some performance tweaks in SVN1112. These make a significant improvement for my test site.

Do they help you?

Greg

[Mark Hattam]

Logged In: YES
user_id=623181
Originator: YES

OK ... did a SVN re-sync. Reimported the GEDCOM in case of any changes in the database.

I'm now 16 minutes into waiting for the placename page to finish rendering in IE7 ... so no appreciable improvement yet noticed.

IE7 is currently maxing out one CPU (2.4 GHz) using 356,650 of memory (and growing), 158,550 handles and 10 threads.

MySQL here is now 5.0.41 and PHP 5.2.2 ... other than that the same.

Now 20 minutes ... it said "done" in the bottom left ages ago, but the blue rendering progress bar is still "progressing". Maybe this is just an IE7 problem, but it's still not promising.

Mark