Re: [SQL-Ledger-users] LARGE INVENTORY

[Martin L. <ma...@li...>]

Thomas Sawyer wrote:

> I have to get this working with this a large inventory. So I'm looking
> at adding some selection criteria limitations to the ic.cgi script. I'm
> thinking of adding limiting criteria where one has to select the first
> and second letter of the search. (i.e. Aa, Ab, Ac...Zx, Zy, Zz) How does
> this sound to you all? Any other ideas?

maybe you should create a new parameter (eq. min_search_str_length) in
configuration page, so people with small inventories (like me) can set
it to 0 and in your case, it can be set to 2, 3 or whatever. then add
code to ic.cgi that displays error message if search string is shorter
than value specified in config. does this make any sense or am I
over-complicating things again? :)

another idea to consider is grouping inventory items, so that you first
select group and then only products belonging to specified group are
displayed.

idea #3 - limit displaying inventory items on one page (does PostgreSQL
have equivalent to MySQL LIMIT?). Maybe implement this throughout the
program + another option to config page?

--
Martin Lillepuu | E-mail: ma...@li... | GSM: 051 56 450