On Nov 16, 2007 5:11 PM, Charley Tiggs <[EMAIL PROTECTED]> wrote:
> Not using departments or projects. Didn't notice any excessive
> swapping. I do notice that it takes a very long time to save an invoice
> that has 20 or more line items on it.
>
> Charley
>
>
Ok, there is a known issue with perf
Not using departments or projects. Didn't notice any excessive
swapping. I do notice that it takes a very long time to save an invoice
that has 20 or more line items on it.
Charley
Chris Travers wrote:
> Hi Charley;
>
> Thanks for the performance metrics. Also are you using departments
> an
Joshua D. Drake wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 16 Nov 2007 18:49:59 -0600
Charley Tiggs <[EMAIL PROTECTED]> wrote:
Joshua D. Drake wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 16 Nov 2007 18:15:27 -0600
Charley Tiggs <[EMAIL PROTECTED]> wrote:
Hi Charley;
Thanks for the performance metrics. Also are you using departments
and/or projects? A customer of mine ran into strange performance
issues at about the same size which we tracked down to query plan
changes.
Also during the problems, did you see excessive CPU usage, swapping,
or othe
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 16 Nov 2007 18:49:59 -0600
Charley Tiggs <[EMAIL PROTECTED]> wrote:
> Joshua D. Drake wrote:
> > -BEGIN PGP SIGNED MESSAGE-
> > Hash: SHA1
> >
> > On Fri, 16 Nov 2007 18:15:27 -0600
> > Charley Tiggs <[EMAIL PROTECTED]> wrote:
> >
>
Chris Travers wrote:
> Also how big is the database? How many rows in: ar, ap, oe, invoice,
> and acc_trans?
>
> I ask because SQL-Ledger and hence LedgerSMB is known to have some
> performance issues that we are still identifying and solving.
> Furthermore, a lot more is going on in the db than
Joshua D. Drake wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On Fri, 16 Nov 2007 18:15:27 -0600
> Charley Tiggs <[EMAIL PROTECTED]> wrote:
>
>> Joshua D. Drake wrote:
> It sounds more like a machine level issue (bad configuration of
> postgresql, not enough IO/RAM etc..)
>
Also how big is the database? How many rows in: ar, ap, oe, invoice,
and acc_trans?
I ask because SQL-Ledger and hence LedgerSMB is known to have some
performance issues that we are still identifying and solving.
Furthermore, a lot more is going on in the db than just posting the
invoice.
Best
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 16 Nov 2007 18:15:27 -0600
Charley Tiggs <[EMAIL PROTECTED]> wrote:
> Joshua D. Drake wrote:
> >>> It sounds more like a machine level issue (bad configuration of
> >>> postgresql, not enough IO/RAM etc..)
> >> Josh,
> > How many connections
Joshua D. Drake wrote:
>>> It sounds more like a machine level issue (bad configuration of
>>> postgresql, not enough IO/RAM etc..)
>> Josh,
>>
>> That was my initial thought on the issue and I spent quite some time
>> trying to run it down over the three days and didn't see where, how I
>> could
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 16 Nov 2007 14:52:39 -0600
Charley Tiggs <[EMAIL PROTECTED]> wrote:
> Joshua D. Drake wrote:
> > -BEGIN PGP SIGNED MESSAGE-
> > Hash: SHA1
> > It sounds more like a machine level issue (bad configuration of
> > postgresql, not enough
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 16 Nov 2007 13:13:35 -0600
Charley Tiggs <[EMAIL PROTECTED]> wrote:
> Just thought I would ask if persistent connections or even connection
> pooling was possible under such a high load environment to at least
> mitigate that kind of situati
Joshua D. Drake wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On Fri, 16 Nov 2007 13:13:35 -0600
> Charley Tiggs <[EMAIL PROTECTED]> wrote:
>
>> Just thought I would ask if persistent connections or even connection
>> pooling was possible under such a high load environment to at l
> However, long-run ,we are working on two things which will make this
> easier. 1) Making the software ready for mod_perl or fast_cgi (note
> though that this will not address your specific issue alone because of
> the fact that each *user* gets his/her own database connection)
You can also use
I understand your issue and by 1.4, I expect that we will have better
options for dealing with it.
Obviously even "persistant" database connections are not very
persistent when they are created in an external process which is
fairly short-lived (as it is when you use the command line or connect
vi
Chris Travers wrote:
> On Nov 16, 2007 10:51 AM, Charley Tiggs <[EMAIL PROTECTED]> wrote:
>> Hello all,
>>
>> Is it possible for LedgerSMB to work with persistent connections to the
>> database? If so, how would I go about making that happen?
> Also, if there are specific other issues you are r
Also note that in the long run, we want LedgerSMB to be capable of
running in a system where the code is cached, such as mod_perl or fast
cgi.
Best Wishes,
Chris Travers
-
This SF.net email is sponsored by: Microsoft
Defy all
On Nov 16, 2007 10:51 AM, Charley Tiggs <[EMAIL PROTECTED]> wrote:
> Hello all,
>
> Is it possible for LedgerSMB to work with persistent connections to the
> database? If so, how would I go about making that happen?
In a CGI structure, I don't believe it is possible. Note however,
that we only u
Hello all,
Is it possible for LedgerSMB to work with persistent connections to the
database? If so, how would I go about making that happen?
Charley
-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Micro
19 matches
Mail list logo
