[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Problem w/POS after SQL-Ledger to Ledgersmb migration



On Tue, May 27, 2008 at 8:21 PM,  <..hidden..> wrote:
>
>
>> Ok.  When you run top on the server during this process, what takes up
>> most of the time.
>>
>> I would bet it is postgres, right?
>>
>> 1)  Do you use departments or projects?
>> 2)  Do you vacuum frequently?
>>
>>Best WIshes,
>>Chris Travers
>>
>> When I run top -i on both servers, I see ps.pl process popup briefly on my
>> Ledgersmb server, and I believe it was postmaster briefly on my Postgresql
>> server.
>> Then nothing for minutes until finally a process for Apache prefork and
>> also a process for Ledgersmb again very briefly.  It doesn't appear that
>> much in the way
>> of resources are getting utilized while I wait.  It is almost like
>> everything goes to sleep for several minutes.  Regarding
>> departments/projects, we use
>> departments, but not projects.  We also have autovacuum setup.
>
> Just a follow-up.  I noticed that when I re-enable dropdowns for the POS
> screen, opening the POS/Sale screen loads fairly quickly and the customer
> dropdown is populated quickly also.  If I select another customer, and then
> click the Update button it takes about three minutes or longer to reload.  I
> am no expert, but it seems to me the problem is around the update
> functionality.  Reviewing the pos.pl code, I noticed two subs called
> "on_update".  Like I said, I am no expert especially when it comes to Perl,
> but that seemed odd to me.  In addition, monitoring both the apache, and
> postgresql logs I don't see anything of interest.

on_update() is used to do things like send UDP packets tot he terminal
for pole display control.

It is not causing problems as far as I know.  Most likely, something
else is going wrong.

Can you attach your pos.conf.pl?
>
> Best Regards,
> Steven Marshall
>
> Taty Lee Boutique
> 11705 Jones Bridge Rd., B206
> Alpharetta, GA 30005
> 770-410-6964
>
> "Once you experience the stylish comfort of Brazilian-cut jeans, you will
> demand nothing less!"
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
>