Re: [Phpgedview-talk] SLOW.... ideas?

[waldo k. <wki...@wi...>]

Randal T. Rioux wrote:
> I'm running the latest PGV on a box with the following specs:

[trim]

> CPU usage never goes over 5%, and the disks don't appear to be thrashing
> or busy. Is there anything I can do? This is unbearable, and this file is
> going to grow as time goes on (major project my father has been working
> on).

where is your slowness being seen? i generally see mine in the calendar applet 
so, at one time, i had simply turned it off in the UI... however, i was also 
able to gain some speed by setting up a couple of additional indexes but i don't 
recall what they were based on... i'm also running mysql for my database and my 
ged was starting in the neighborhood of 24megs...

it has been a while since i've worked with any of it and so i don't know how it 
would be today with the changes i've made with my servers... i guess i should 
see about doing something with it... maybe moving it from the front server to 
one of the backend dually 800's... heck, i don't even recall what version of PGV 
i'm running and it has been a while since i last updated to a newer version... 
i'd guess that i'm maybe 3 or 4 dot versions behind...

[time passes]

i just went and took a look... i've got PGV 4.0.2 and yeah, the calendar takes a 
minute to load up... dunno if that's due to the speed of the database server or 
the web server that i currently have PGV mounted on, or the speed of my 
workstation, though :?

the stats at the bottom of the page show the following...

Execution time: 56.827 sec. Total Database Queries: 243. Total privacy checks: 34.

subsequent loadings of the same page (ie: back button and then forward button) 
give (much) faster times...

Execution time: 11.166 sec. Total Database Queries: 58. Total privacy checks: 33.

dunno if that helps out any...

my database stats, according to the initial PGV page are...

Individuals  	29023
Total surnames 	1857
Families 	10397
Sources 	291
Other Records 	118
Total events 	55499

and i'm _not_ logging in... maybe this helps... maybe not...

-- 
        _\/
       (@@)                      Waldo Kitty, Waldo's Place USA
__ooO_( )_Ooo_____________________ telnet://bbs.wpusa.dynip.com
_|_____|_____|_____|_____|_____|_____ http://www.wpusa.dynip.com
____|_____|_____|_____|_____|_____|_____ ftp://ftp.wpusa.dynip.com
_|_Eat_SPAM_to_email_me!_YUM!__|_____|_____ wkitty42 -at- alltel.net


---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 080513-0, 05/13/2008
Tested on: 5/13/08 16:47:54
avast! - copyright (c) 1988-2008 ALWIL Software.
http://www.avast.com