ID |
Date |
Icon |
Author |
Author Email |
Category |
OS |
ELOG Version |
Subject |
2323
|
Sat Oct 6 15:44:51 2007 |
| Stefan Ritt | stefan.ritt@psi.ch | Question | Windows | 2.6.5-1890 | Re: testing for the limit of the elog database |
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!) |
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 ? |
65620
|
Sat Oct 6 14:05:01 2007 |
| | | | | | |
I ended with 125384 entries like the one above.
Everything works fine but ......... [U]tteerrrriibbllee[/U] [B]slow[/B]. CPU usage is constant at 99%.
I tried to split the one file produced by the import into 2 chunks but that did not improve the situation.
My question is : Is there a rule of thumb for the size of the "database" in which elog keeps it's performance, or better : is there a solution for this for elog.
|
2321
|
Thu Oct 4 17:19:56 2007 |
| Stefan Ritt | stefan.ritt@psi.ch | Request | | ELOG V2.6. | Re: Add date and time stamp to file upload |
Fergus Lynch wrote: | I would like to request a new feature - add date and time stamp to file upload. We use ELOG (amongst other things!) as a change log and this would really allow allow more accurate records to be kept. For instance we upload router config files (to record changes)and having the exact upload date would be a big enhancement, especially when there are a lot of attachments. |
There is already a time and a date stamp. If you look in the logbook directory, you see attachments preceded with the date and time when they were submitted. You can see this date/time when you click on the attachment, such as in
http://midas.psi.ch/elogs/Config+Examples/040519_000348/elogd.cfg
where you will see it even in the URL (May 19th, 2004, 0:03:48) in the above case. I agree that this is not so obvious. If you make a proposal where this date/time should be displayed, I can easily add it. |
2320
|
Thu Oct 4 12:03:30 2007 |
| Fergus Lynch | flynch@alternativenetworks.com | Request | | ELOG V2.6. | Add date and time stamp to file upload |
Hi,
Been using ELOG for a couple of years now and I am very impressed with its functionality.
I would like to request a new feature - add date and time stamp to file upload. We use ELOG (amongst other things!) as a change log and this would really allow allow more accurate records to be kept. For instance we upload router config files (to record changes)and having the exact upload date would be a big enhancement, especially when there are a lot of attachments.
Many Thanks in Advance
Fergus |
2319
|
Fri Sep 28 17:52:37 2007 |
| Stefan Ritt | stefan.ritt@psi.ch | Question | Linux | Windows | 2.6.5-1844 | Re: Post appearing twice |
Bertram Metz wrote: | I've observed the same behavior with attributes containing a dash. Would it be possible to allow '-' in attributes? |
Yes. Fixed in Revision 1930. |
2318
|
Thu Sep 27 15:18:10 2007 |
| Bertram Metz | Bertram.Metz@gefanuc.com | Question | Linux | Windows | 2.6.5-1844 | Re: Post appearing twice |
I've observed the same behavior with attributes containing a dash. Would it be possible to allow '-' in attributes?
Bertram |
2317
|
Tue Sep 11 21:25:11 2007 |
| Stefan Ritt | stefan.ritt@psi.ch | Request | All | 2.6.2-1739 | Re: Too many logbooks during user registration |
Steve Jones wrote: | So the list is shown to the one requesting the registration? Would it be possible to have an option that, when selected, simply did not list any logbooks? I can see a customer becoming confused if they did not see their logbook listed. Just turn off the selection completely. Otherwise, this will work but I fear will generate more questions as in "Why isn't logbook <blah> listed?" |
I agree, that's inconsistent. So I removed the logbook list completely (SVN revision 1914) and added a note on the user notification that they should click 'config' to subscribe to any logbook. |