| ID |
Date |
Icon |
Author |
Author Email |
Category |
OS |
ELOG Version |
Subject |
|
2322
|
Sat Oct 6 15:39:12 2007 |
 | Arno Teunisse | A.Teeling3@chello.nl | Question | Windows | 2.6.5-1890 | testing for the limit of the elog database | Hello
To test elog i created a very large databasefile ( 071006a.log = 39MB ) via an import.
Nothing special. At the import I already got a message to increase "Max content length" to 22420822 in the global section. Below is the what i've done. There are no attachments involved, as you can see.
[global]
port = 80;
Max content length = 22420822
[DAP]
Theme = default
Attributes=Klant,Doc
Quick filter = Klant
So there are only 2 user defined fields in the database.
Everything works ......... but terrible slow : is there a rule of thumb for the size of the database ? |
|
2324
|
Sat Oct 6 15:56:13 2007 |
 | Arno Teunisse | A.Teeling3@chello.nl | Question | Windows | 2.6.5-1890 | Re: testing for the limit of the elog database |
| Stefan Ritt wrote: |
| Arno Teunisse wrote: | So there are only 2 user defined fields in the database.
Everything works ......... but terrible slow : is there a rule of thumb for the size of the database ? |
Yes. The rule of thumb is that currently elog runs fine for a few 10000 entries. At 100000 entries it starts getting slow. I have already in my to-do list the task to improve the performance for large databases, and I have a rough idea where the bottleneck is, but I pushed the priority low because not many people have large databases right now (but it might change in the future). How many entries do you have? (It's not the size of the entries, but the number!) |
That's a quick answer.  I just was testing. I'm trying to introduce elog at work, so i'm not having an actual database in production. In the test database I had 125386 entries. Two column: "Customers name" and "documents".
By the way : my email address has changed : how do I change that ??
Thanks |
|
2326
|
Sat Oct 6 16:47:44 2007 |
 | Arno Teunisse | A.teeling3@chello.nl | Question | Windows | | how to use the find calendar | Hello
In the find page you use a calendar popup from which the user can click on a date and the date boxes are filled in with the correct date. Can I use that calendar also? If so, can you show me an example of it's usage. |
|
2327
|
Sat Oct 6 17:15:59 2007 |
| Arno Teunisse | A.teeling3@chello.nl | Question | Windows | | Re: how to use the find calendar |
| Arno Teunisse wrote: | Hello
In the find page you use a calendar popup from which the user can click on a date and the date boxes are filled in with the correct date. Can I use that calendar also? If so, can you show me an example of it's usage.
I found it , Sorry for the question, ( RTFM ) Read The Fucking Manual )
|
|
|
2329
|
Sat Oct 13 15:32:23 2007 |
 | Arno Teunisse | A.teeling3@chello.nl | Question | Windows | 2.6.5-1890 | extendable options | Hello
running ELOG V2.6.5-1890
Snap of the config file :
=======================
; attributes
Attributes = OS, Version, Klant , Category, Subject
Options OS = AIX{1}, HP-UX{2} , Redhat{3} , Suse{4}, Fedora{5}, SUN{6}
Options Category = Documentation, disk , network , software , backup , boot,
Options Klant = None, Cust1 , Cust2 , Cust3 , Cust4, Cust5
{1} options Version = 4.3, 5.1 , 5.2 ,5.3
{2} options Version = 10.20, 11.11, 11.23
{3} options Version = 4.0
{4} options Version = 10.0
{5} options Version = 5.0,6.0,7.0
{6} options Version = 5.6,5.7,5.8,5.9,5.10
extendable Options = Category, Klant, OS , Version
============ end of snap
When I click the "Add Version" button Elog end's with a "Internal error, no
valid header!" after hitting the submit button. ( See attachments )
An other problem is when I add a new OS and a new Version at the same time. The
OS is added , ( without the {7} extension.) and no new "{7} options version = "
gets added.
Is there a way to get this going? |
| Attachment 1: debug_screen.txt
|
POST /Accelerator/ HTTP/1.1
Accept: image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-
erpoint, application/msword, */*
Referer: http://localhost/Accelerator/
Accept-Language: nl
Content-Type: multipart/form-data; boundary=---------------------------7d74
UA-CPU: x86
Accept-Encoding: gzip, deflate
User-Agent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; InfoPath.1;
Host: localhost
Content-Length: 2045
Connection: Keep-Alive
Cache-Control: no-cache
Cookie: elmode=summary; elattach=1; unm=arnot; upwd=d2Vsa29t; urem=1
-----------------------------7d74ef30116
Content-Disposition: form-data; name="jcmd"
-----------------------------7d74ef30116
Content-Disposition: form-data; name="smcmd"
-----------------------------7d74ef30116
Content-Disposition: form-data; name="inlineatt"
-----------------------------7d74ef30116
Content-Disposition: form-data; name="cmd"
Update
-----------------------------7d74ef30116
Content-Disposition: form-data; name="cmd"
Submit
-----------------------------7d74ef30116
Content-Disposition: form-data; name="entry_date"
Sat Oct 13 15:09:04 2007
-----------------------------7d74ef30116
Content-Disposition: form-data; name="condition"
4
-----------------------------7d74ef30116
Content-Disposition: form-data; name="OS"
Suse
-----------------------------7d74ef30116
Content-Disposition: form-data; name="Version"
11.0
-----------------------------7d74ef30116
Content-Disposition: form-data; name="extend_1"
1
-----------------------------7d74ef30116
Content-Disposition: form-data; name="Klant"
Geen
-----------------------------7d74ef30116
Content-Disposition: form-data; name="Category"
Documentation
-----------------------------7d74ef30116
Content-Disposition: form-data; name="Subject"
test
-----------------------------7d74ef30116
Content-Disposition: form-data; name="font"
0
-----------------------------7d74ef30116
Content-Disposition: form-data; name="size"
0
-----------------------------7d74ef30116
Content-Disposition: form-data; name="color"
0
-----------------------------7d74ef30116
Content-Disposition: form-data; name="Text"
test
-----------------------------7d74ef30116
Content-Disposition: form-data; name="encoding"
ELCode
-----------------------------7d74ef30116
Content-Disposition: form-data; name="next_attachment"
1
-----------------------------7d74ef30116
Content-Disposition: form-data; name="attfile"; filename=""
Content-Type: application/octet-stream
-----------------------------7d74ef30116--
Internal error, no valid header!
|
| Attachment 2: elog.JPG
|
|
|
2330
|
Thu Oct 18 23:18:03 2007 |
| Arno Teunisse | A.teeling3@chello.nl | Question | Windows | V2.6.5-189 | default css style | The default tiny.css has a bug in it.
It's calling a class that does not exists. The class name is : list1h and list2h. So I added :
/* Just highlighting the last entries , Added by Arno Teunisse . Elog is calling
these, but they are not defined in the css style sheets*/
.list1h { border:1px solid #3080FF;
border-top:1px solid white;
border-left:1px solid white;
background-color:Yellow;
text-align:center;
}
.list2h {
border:1px solid #3080FF;
border-top:1px solid white;
border-left:1px solid white;
background-color:Yellow;
text-align:center;
}
If these are NOT defined the user that edit's an entrie and does a "list" afterwards get's the colorization of a menu and all is shifted onto the left.
with kind regards
Arno Teunisse
|
|
65622
|
Fri Oct 19 22:59:31 2007 |
| Arno Teunisse | A.teeling3@chello.nl | Info | Windows | 2.6.5-1890 | Quick Filter and boolean option question | ; BUG : When "Contract" is at the second position in the "Attributes".
; We See in the "Quick Filter" a pulldown showing "Serial Number" with only "0" or "1" ,
; this is NOT what i want or is expected !!!
[WRONG]
Attributes = Server , Contract , ContractID, Serienummer,Locatie , Category , TEST4
Options Category = Server, Printer , Disk, Router
; Please notice that the boolean attribute is at the second position in the attributes <list>,
;this is a bug, otherwise the "Quick Filter" gets it wrong. So Boolean attributes must always
;be the last item when defining the Attributes
Options Contract = boolean
Quick Filter = Server , Serienummer , Category
; This is OK : Just moving the "Contract" to the end of the "Attributes"
; Now the "Quick Filter" is a normal entrie field and not a pulldown.
; So , now i can enter a serialnumber. This is what i want and is expected.
[OK]
Attributes = Server , ContractID, Serienummer,Locatie , Category , TEST4 , Contract
Options Category = Server, Printer , Disk, Router
; Please notice that the boolean attribute is the last in the attributes <list>, this is a bug, otherwise the "Quick Filter" gets it wrong. So Boolean attributes must always be the last item when defining the Attributes
Options Contract = boolean
Quick Filter = Server , Serienummer , Category
Just switch between "wrong" and "OK" to see the "quick filter" changes. |
|
65623
|
Sun Oct 21 00:17:34 2007 |
| Arno Teunisse | A.teeling3@chello.nl | Info | Windows | 2.6.5-1890 | Re: Quick Filter and boolean option question |
| Arno Teunisse wrote: | ; BUG : When "Contract" is at the second position in the "Attributes".
; We See in the "Quick Filter" a pulldown showing "Serienummer" with only "0" or "1" ,
; this is NOT what i want or is expected !!!
[WRONG]
Attributes = Server , Contract , ContractID, Serienummer,Locatie , Category , TEST4
Options Category = Server, Printer , Disk, Router
; Please notice that the boolean attribute is at the second position in the attributes <list>,
;this is a bug, otherwise the "Quick Filter" gets it wrong. So Boolean attributes must always
;be the last item when defining the Attributes
Options Contract = boolean
Quick Filter = Server , Serienummer , Category
; This is OK : Just moving the "Contract" to the end of the "Attributes"
; Now the "Quick Filter" is a normal entrie field and not a pulldown.
; So , now i can enter a Serialnumber. This is what i want and is expected.
[OK]
Attributes = Server , ContractID, Serienummer,Locatie , Category , TEST4 , Contract
Options Category = Server, Printer , Disk, Router
; Please notice that the boolean attribute is the last in the attributes <list>, this is a bug, otherwise the "Quick Filter" gets it wrong. So Boolean attributes must always be the last item when defining the Attributes
Options Contract = boolean
Quick Filter = Server , Serienummer , Category
Just switch between "wrong" and "OK" to see the "quick filter" changes. |
| Arno Teunisse wrote: |
Hello again
Maybe it's not nice to begin with "BUG:" but i was in a hurry. Sorry for that.
Because I did not get an answer i think i must ask it in an other way : De [WRONG] and [OK] configurations are identical except for the order in which the Attributes appear. This causes the "Quick Filter" problem, as you can see when changing between the [Wrong] and [OK] tabs.
Am I missing some config setting or i am lost here ?
By the way : I see you are running version 2.6.5-1937. Is there a windows version of that too ?
with kind regards
|
|
|