On Tue, May 27, 2008 at 8:21 PM, <[EMAIL PROTECTED]> 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 > Ledger-smb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > > ------------------------------------------------------------------------- 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 Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
