phpgedview-talk

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

[Randal T. R. <ra...@pr...>]

I'm running the latest PGV on a box with the following specs:

# Hardware: IBM eServer 325
# CPU: 2x AMD Opteron SledgeHammer 246 2Ghz
# O/S: OpenBSD 4.3 AMD64
# RAM: 1GB

The PostgreSQL database is running the following specs:

# Hardware: Sun Netra t 1125
# CPU: 2x 440Mhz UltraSPARC-II
# O/S: Solaris 10 05/08
# RAM: 1GB

The .ged file is 37MB and has been cleaned and cared for. The database has
been vacuumed and tuned. I have also tried running PGV on a quad CPU Sun
420R with 4GB RAM (Solaris 10) and a dual Xeon 2.66Ghz 4GB RAM (CentOS
Linux), with the exact same slow performance. See for yourself:

https://meteor.procyonlabs.com/pgv

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).

I appreciate any advice. Thanks!

Randy

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

[Phpgedview-talk] GEDCOM Import DB Error

[Randal T. R. <ra...@pr...>]

I get this error when importing a ~33MB .ged file:

ERROR:-2 DB Error: syntax error
SQL:CREATE TABLE pgv_nextid (ni_id INT UNSIGNED NOT NULL, ni_type
VARCHAR(30) NOT NULL, ni_gedfile INT NOT NULL, PRIMARY KEY(ni_type,
ni_gedfile)) [nativecode=ERROR: syntax error at or near "UNSIGNED" at
character 36]

Any ideas? I'm using PostgreSQL.

Thanks!
Randy

Re: [Phpgedview-talk] GEDCOM Import DB Error

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

Randal T. Rioux wrote:
> I get this error when importing a ~33MB .ged file:
> 
> ERROR:-2 DB Error: syntax error
> SQL:CREATE TABLE pgv_nextid (ni_id INT UNSIGNED NOT NULL, ni_type
> VARCHAR(30) NOT NULL, ni_gedfile INT NOT NULL, PRIMARY KEY(ni_type,
> ni_gedfile)) [nativecode=ERROR: syntax error at or near "UNSIGNED" at
> character 36]
> 
> Any ideas? I'm using PostgreSQL.

what version? is the above sql query valid for that version?

i ask because i just recently upgraded to the latest v4.1.5 and many queries 
were failing with my mysql v3.23.58 didn't recognise (or otherwise like) the 
queries as written... so i quickly altered my settings to point to a newer mysql 
and everything is now working, albeit slowly which is causing me to look at 
several options to move the database to a faster server... considering that i 
host my sites on numerous servers, here in my physical location, the easiest 
appears to me to set the new server as a slave to the (secondary) existing 
server to move/copy everything over and then to swap the settings and set the 
3rd server up as a primary for this one task/database :?

oh how i wish things were really (a lot more) optimized with this application 
(ie: the googlemap stuff could really use at least one index that covers the 
entire range of locations instead of one index for each level :? ) :? :? ;) ;) ;)

-- 
NOTE: NEW EMAIL ADDRESS!!

        _\/
       (@@)                      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- windstream.net


---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 080902-0, 09/02/2008
Tested on: 9/2/08 23:54:17
avast! - copyright (c) 1988-2008 ALWIL Software.
http://www.avast.com

Re: [Phpgedview-talk] GEDCOM Import DB Error

[Randal T. R. <ra...@pr...>]

On Tue, September 2, 2008 11:54 pm, waldo kitty wrote:
> Randal T. Rioux wrote:
>> I get this error when importing a ~33MB .ged file:
>>
>> ERROR:-2 DB Error: syntax error SQL:CREATE TABLE pgv_nextid (ni_id INT
>> UNSIGNED NOT NULL, ni_type VARCHAR(30) NOT NULL, ni_gedfile INT NOT
>> NULL, PRIMARY KEY(ni_type, ni_gedfile)) [nativecode=ERROR: syntax error
>> at or near "UNSIGNED" at character 36]
>>
>> Any ideas? I'm using PostgreSQL.
>
> what version? is the above sql query valid for that version?

Good question - PGV v4.1.5 and PostgreSQL 8.2.9 (Solaris 10 - SPARC). I'll
look over the SQL statement later to check validity.

> i ask because i just recently upgraded to the latest v4.1.5 and many
> queries were failing with my mysql v3.23.58 didn't recognise (or
> otherwise like) the queries as written... so i quickly altered my
> settings to point to a newer mysql and everything is now working, albeit
> slowly which is causing me to look at several options to move the
> database to a faster server... considering that i host my sites on
> numerous servers, here in my physical location, the easiest appears to me
> to set the new server as a slave to the (secondary) existing server to
> move/copy everything over and then to swap the settings and set the 3rd
> server up as a primary for this one task/database :?

As I've mentioned on the list before, I too have struggled with the speed
issues. Maybe I'll send in some patches at some point :-)

> oh how i wish things were really (a lot more) optimized with this
> application (ie: the googlemap stuff could really use at least one index
> that covers the entire range of locations instead of one index for each
> level :? ) :? :? ;) ;) ;)

Ditto!

Thanks,
Randy