sql-ledger-users

Large numbers of Customers

[Eric M. <em...@ra...>]

I'm preparing to evaluate SQL-Ledger as a replacement to the accounting
package my wife is using at her office.  I just looked at one of the
demo systems.  I'm curious about how well it scales up to larger
customer databases.  Is there anyone using SQL-Ledger with > 5000
customers?  It seems like the customer selection in the Invoice entry
screen would be unwieldy with more than a few hundred customers.

Re: Large numbers of Customers

[alta <al...@al...>]

Eric ...

Re: Your question about 5000 or more customers.

My customer DB has 4000 customers.  My observations follow:

- Speed of the DB is adequate, but I had problems with browsers.

- The pull-down list on the invoice form is so long that Konqueror 
misbehaves.  Transitioning from the Invoice screen to the Print 
Invoice screen hangs the CPU for 45 seconds!  So, I must use mozilla.

- Finding the customer in the pull-down list is a chore.  I would 
rather have no pull-down list, search for the customer in the 
customer search form, then go to the invoice form and have the 
correct customer waiting for me.  I modified Version 1.6 to do this, 
but have not yet gotten around to modifying Version 1.8.  The change 
allowed Konqueror to work quickly, and was user-friendly.

- I also modified Version 1.6 so that the new Invoice would display 
the last customer created, unless the Invoice screen was entered via 
the customer search screen.  In the latter case, the Invoice screen 
displayed the last customer looked-at, which I feel is an important 
usability concept.

Much of the credit for these mods goes to Dieter, who was helpful in 
suggestion ways to do it.

... Reed

Re: Large numbers of Customers

[Dieter S. <dsi...@sq...>]

The default customer is the last customer you used when you a) added a
new AR transaction or invoice or b) when you edited a transaction or
invoice.

The same principle applies to order entry and vendor invoices and AP
transactions.

I have to dig up the 'POS' and plug it into the code yet. It's probably
going to be in one of the patch release.


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Thu, 3 Jan 2002, alta wrote:

> 
> Eric ...
> 
> Re: Your question about 5000 or more customers.
> 
> My customer DB has 4000 customers.  My observations follow:
> 
> - Speed of the DB is adequate, but I had problems with browsers.
> 
> - The pull-down list on the invoice form is so long that Konqueror 
> misbehaves.  Transitioning from the Invoice screen to the Print 
> Invoice screen hangs the CPU for 45 seconds!  So, I must use mozilla.
> 
> - Finding the customer in the pull-down list is a chore.  I would 
> rather have no pull-down list, search for the customer in the 
> customer search form, then go to the invoice form and have the 
> correct customer waiting for me.  I modified Version 1.6 to do this, 
> but have not yet gotten around to modifying Version 1.8.  The change 
> allowed Konqueror to work quickly, and was user-friendly.
> 
> - I also modified Version 1.6 so that the new Invoice would display 
> the last customer created, unless the Invoice screen was entered via 
> the customer search screen.  In the latter case, the Invoice screen 
> displayed the last customer looked-at, which I feel is an important 
> usability concept.
> 
> Much of the credit for these mods goes to Dieter, who was helpful in 
> suggestion ways to do it.
> 
> ... Reed
> 
> 
> 
> 
>