PJ Meyer wrote: | I finally got 2.60 Beta3 running on my server (explicit statements in cfg for most of the defaults)
Now I'm seeing a veerrry slooooow response time - over 3 minutes to open a logbook vs 10 sec in 2.54
Utilization of CPU runs to 60% on elogd.
Tried slimning down elog.cfg, 'emptying' userlog file (actually renamed so Elog created a new one).
Still 2.60b3 is very slow to respond.
When I rolled back to 2.54 speed was fast again.
Any ideas?
this is on a dual processor Win2000 server with 2 gb memory.
attached is the elog.cfg if that helps.
i'm stumped
7/28 Follow-up testing and trials
When I stopped using a password file - speed was quick and responsive (on test book with no password file speed was good which got me thinking about the password file)
When I added back in the 'old' xml password file - slow response
I created new password file with only one user - slow response (took almost 3 minutes to save new account)
I've attached the password file so you can try it out if yo want....
This has me very stumped. |
I can confirm .. it's very very slow for me too:
munmap(0xb7db4000, 4096) = 0
select(1024, [5], NULL, NULL, {6, 0}) = 1 (in [5], left {5, 996000})
recv(5, "GET /calendar_filter/imgs/window"..., 100000, 0) = 485
open("/usr/share/elog/scripts/calendar_filter/imgs/window_close.gif", O_RDONLY) = 6
close(6) = 0
open("/usr/share/elog/scripts/calendar_filter/imgs/window_close.gif", O_RDONLY) = 6
lseek(6, 0, SEEK_END) = 648
lseek(6, 0, SEEK_CUR) = 648
lseek(6, 0, SEEK_SET) = 0
time([1123066183]) = 1123066183
read(6, "GIF89a\20\0\20\0\306`\0\16\26 \r\27!\16\30!\24 .\25 .I"..., 648) = 648
close(6) = 0
send(5, "HTTP/1.1 200 Document follows\r\nS"..., 879, 0) = 879
close(5) = 0
select(1024, [3], NULL, NULL, {1, 0}) = 0 (Timeout)
select(1024, [3], NULL, NULL, {1, 0}) = 0 (Timeout)
select(1024, [3], NULL, NULL, {1, 0}) = 0 (Timeout)
select(1024, [3], NULL, NULL, {1, 0}) = 0 (Timeout)
select(1024, [3], NULL, NULL, {1, 0}) = 0 (Timeout)
select(1024, [3], NULL, NULL, {1, 0}) = 0 (Timeout)
select(1024, [3], NULL, NULL, {1, 0}) = 0 (Timeout)
select(1024, [3], NULL, NULL, {1, 0}) = 0 (Timeout)
select(1024, [3], NULL, NULL, {1, 0}) = 0 (Timeout)
select(1024, [3], NULL, NULL, {1, 0}) = 1 (in [3], left {0, 81000})
accept(3, {sa_family=AF_INET, sin_port=htons(57723), sin_addr=inet_addr("127.0.0.1")}, [16]) = 5
time(NULL) = 1123066193
socket(PF_FILE, SOCK_STREAM, 0) = 6
connect(6, {sa_family=AF_FILE, path="/var/run/.nscd_socket"}, 110) = -1 ENOENT (No such file or directory)
close(6) = 0
for every image elog has to serve one can see something similar to the above ... lot of time lost in selects.. then a lot of data (serving an image I suppose), then a lot of time in select again and again ... untill everything is sent, in a couple of minutes or more 
Maybe an issue related to the dns search you introduced in order to guess the correct host name ?? .. |
[global]
Language = German
Theme = default
logbook tabs = 1
main tab = INHALT
welcome title = <b><big>Ulrich Rolf Trüssel</big></b> Adressverwaltung (Geschäft & Privat) Mensch-Tier Coaching™ - Mensch-Hund Coaching™ Interessengemeinschaft Familienhund® - Regionalgruppe Zentralschweiz Lorenz Tierschule
port = 8080
Theme = default
Message Width = 100
Message Height = 25
Filtered browsing = 1
Suppress default = 2
Suppress Email on Edit = 0
Email Format = 0
Filtered browsing = 1
HTML default = 3
Reverse sort = 1
Quote on replay = 0
[Kurse]
Title image = <img border=0 src="ELOG_URT.gif" alt="Mensch-Hund Coaching(TM) ELOG">
comment = Ulrich Rolf Trüssel - Mensch-Hund Coaching™ - <a href="http://www.problemhund.ch:8080/Hundeschule%20&%20aktuelle%20Kurse/" target="_blank">Hundeschule</a>
Start Page = ?rsort=StartDatum&Status=WARTELISTE|LAUFEND
Attributes = StartDatum, EndDatum, Wochentag, Zeit, Kurs, Status, Lektionen, Preis, Max., Min., TeilnehmerInnen, WiederholerInnen, KlientIn 1, Definitv 1, WiederholerIn 1, Bezahlt 1, Lektionen 1, KlientIn 2, Definitv 2, WiederholerIn 2, Bezahlt 2, Lektionen 2, KlientIn 3, Definitv 3, WiederholerIn 3, Bezahlt 3, Lektionen 3, KlientIn 4, Definitv 4, WiederholerIn 4, Bezahlt 4, Lektionen 4, KlientIn 5, Definitv 5, WiederholerIn 5, Bezahlt 5, Lektionen 5, KlientIn 6, Definitv 6, WiederholerIn 6, Bezahlt 6, Lektionen 6, Bewertung URT, Referenz
List Display = Ändern, Kurs, Status, StartDatum, EndDatum, Wochentag, Zeit
Format EndDatum = 1
Format Zeit = 1, attribname, attribvalue, 10, 10
Format Preis = 1
Format Status = 1
Format Max. = 0, attribname, attribvalue1, 5, 5
Format Min. = 1, attribname, attribvalue1, 5, 5
Format TeilnehmerInnen = 1, attribname, attribvalue1, 5, 5
Format WiederholerInnen = 1, attribname, attribvalue1, 5, 5
Format KlientIn 1 = 0, attribname, attribvalue2
Format Bezahlt 1 = 1
Format Lektionen 1 = 1
Format Definitv 1 = 1
Format KlientIn 2 = 0, attribname, attribvalue2
Format Bezahlt 2 = 1
Format Lektionen 2 = 1
Format Definitv 2 = 1
Format KlientIn 3 = 0, attribname, attribvalue2
Format Bezahlt 3 = 1
Format Lektionen 3 = 1
Format Definitv 3 = 1
Format KlientIn 4 = 0, attribname, attribvalue2
Format Bezahlt 4 = 1
Format Lektionen 4 = 1
Format Definitv 4 = 1
Format KlientIn 5 = 0, attribname, attribvalue2
Format Bezahlt 5 = 1
Format Lektionen 5 = 1
Format Definitv 5 = 1
Format KlientIn 6 = 0, attribname, attribvalue2
Format Bezahlt 6 = 1
Format Lektionen 6 = 1
Format Definitv 6 = 1
Format Referenz = 0, attribvalue2, attribvalue2
Icon comment icon13.gif = schlecht
Icon comment icon5.gif = unterdurchschnittlich
Icon comment icon2.gif = gut / durchschnittlich
Icon comment icon14.gif = überdurchschnittlich
IOptions Bewertung URT = icon13.gif, icon5.gif, icon2.gif, icon14.gif
Options Status = WARTELISTE, LAUFEND, Abgeschlossen, Abgebrochen
Preset Status = WARTELISTE
Options Kurs = Basis-Kurs 1{1}, Basis-Kurs 2{2}, Click for Live©{3}, Click for Work©{4}, Click&Trick©{5}, Click on Trail©{6}, Milieu-Training{11}, Click for Success©{7}, Doggie-Walk{8}, Spezialkurs{10}
{1, 2} Preset Preis = 270
{3, 7} Preset Preis = 200
{4, 5} Preset Preis = 300
{6, 11} Preset Preis = 400
{8} Preset Preis = 30
{1, 2, 4, 5} Preset Lektionen = 6
{3} Preset Lektionen = 4
{6, 11} Preset Lektionen = 8
{7} Preset Lektionen = 1
{1, 2, 3, 4} Preset Max. = 4
{1, 2, 3, 4} Preset Min. = 2
{1, 2, 3, 4} Preset TeilnehmerInnen = 4
{1, 2, 3, 4} Preset WiederholerInnen = 0
{5} Preset Max. = 3
{5} Preset Min. = 2
{5} Preset TeilnehmerInnen = 3
{5} Preset WiederholerInnen = 0
{6, 11} Preset Max. = 4
{6, 11} Preset Min. = 2
{6, 11} Preset TeilnehmerInnen = 3
{6, 11} Preset WiederholerInnen = 2
{7} Preset Max. = 12
{7} Preset Min. = 8
{7} Preset TeilnehmerInnen = 12
{7} Preset WiederholerInnen = 0
{8} Preset Max. = 6
{8} Preset Min. = 2
{8} Preset TeilnehmerInnen = 6
{8} Preset WiederholerInnen = 0
MOptions Wochentag = MO, DI, MI, DO, FR, SA, SO
ROptions Bezahlt 1 = OFFEN, Nein in Kulanz, Nein Probelektion, RECHNUNG, BAR
{1, 2, 4, 5} MOptions Lektionen 1 = 1, 2, 3, 4, 5, 6, weitere
{3} MOptions Lektionen 1 = 1, 2, 3, 4, weitere
{6, 11} MOptions Lektionen 1 = 1, 2, 3, 4, 5, 6, 7, 8, weitere
{7} MOptions Lektionen 1 = 1
Preset Bezahlt 1 = OFFEN
ROptions Bezahlt 2 = OFFEN, Nein in Kulanz, Nein Probelektion, RECHNUNG, BAR
{1, 2, 4, 5} MOptions Lektionen 2 = 1, 2, 3, 4, 5, 6, weitere
{3} MOptions Lektionen 2 = 1, 2, 3, 4, weitere
{6, 11} MOptions Lektionen 2 = 1, 2, 3, 4, 5, 6, 7, 8, weitere
{7} MOptions Lektionen 2 = 1
Preset Bezahlt 2 = OFFEN
ROptions Bezahlt 3 = OFFEN, Nein in Kulanz, Nein Probelektion, RECHNUNG, BAR
{1, 2, 4, 5} MOptions Lektionen 3 = 1, 2, 3, 4, 5, 6, weitere
{3} MOptions Lektionen 3 = 1, 2, 3, 4, weitere
{6, 11} MOptions Lektionen 31 = 1, 2, 3, 4, 5, 6, 7, 8, weitere
{7} MOptions Lektionen 3 = 1
Preset Bezahlt 3 = OFFEN
ROptions Bezahlt 4 = OFFEN, Nein in Kulanz, Nein Probelektion, RECHNUNG, BAR
{1, 2, 4, 5} MOptions Lektionen 4 = 1, 2, 3, 4, 5, 6, weitere
{3} MOptions Lektionen 4 = 1, 2, 3, 4, weitere
{6, 11} MOptions Lektionen 4 = 1, 2, 3, 4, 5, 6, 7, 8, weitere
{7} MOptions Lektionen 4 = 1
Preset Bezahlt 4 = OFFEN
ROptions Bezahlt 5 = OFFEN, Nein in Kulanz, Nein Probelektion, RECHNUNG, BARr
{1, 2, 4, 5} MOptions Lektionen 5 = 1, 2, 3, 4, 5, 6, weitere
{3} MOptions Lektionen 5 = 1, 2, 3, 4, weitere
{6, 11} MOptions Lektionen 5 = 1, 2, 3, 4, 5, 6, 7, 8, weitere
{7} MOptions Lektionen 5 = 1
Preset Bezahlt 5 = OFFEN
ROptions Bezahlt 6 = OFFEN, Nein in Kulanz, Nein Probelektion, RECHNUNG, BAR
{1, 2, 4, 5} MOptions Lektionen 6 = 1, 2, 3, 4, 5, 6, weitere
{3} MOptions Lektionen 6 = 1, 2, 3, 4, weitere
{6, 11} MOptions Lektionen 6 = 1, 2, 3, 4, 5, 6, 7, 8, weitere
{7} MOptions Lektionen 6 = 1
Preset Bezahlt 6 = OFFEN
Type StartDatum = date
Type EndDatum = date
Type Zeit = numeric
Type Preis = numeric
Type Lektionen = numeric
Type Definitv 1 = date
Type Definitv 2 = date
Type Definitv 3 = date
Type Definitv 4 = date
Type Definitv 5 = date
Type Definitv 6 = date
Options WiederholerIn 1 = boolean
Options WiederholerIn 2 = boolean
Options WiederholerIn 3 = boolean
Options WiederholerIn 4 = boolean
Options WiederholerIn 5 = boolean
Options WiederholerIn 6 = boolean
Date Format = %A, %d. %b. %Y
Extendable Options = Kurs
Display Referenz = [elog:$logbook/$message id]
Required Attributes = Kurs, Lektionen, Preis, Status, Max., Min., TeilnehmerInnen, WiederholerInnen, Bezahlt 1, Bezahlt 2, Bezahlt 3, Bezahlt 4, Bezahlt 5, Bezahlt 6
Page Title = ELOG - $Kurs : $Status : $StartDatum : $EndDatum
Quick filter = Wochentag, Kurs, Status, Bewertung URT
Enable attachments = 0
Show attachments = 1
Resubmit default = 2
Summary lines = 0
|