Re: [SQL-Ledger-users] LARGE INVENTORY

[Thomas S. <ps...@on...>]

Yes to #3!

After some more thought #3 is what I came up with too. That is to say:
It would be most convinent I think to simply put a limit on the number
of records returned.  There could be a criteria field adjusted from the
search page for maximum flexiblity where 0 or blank could mean return
all records and it could default to say 1000 or default from a new field
added to the user record(or where?) For now I'm just going to see if
I can hardcode a LIMIT of 1000 in the SQL statment. That is if Postgres
supports the LIMIT clause like MySQL does. Otherwise I'll have to put
a limit on the loop that generates the HTML. Either way, but the SQL
way would be more efficient.

 
Thomas Sawyer
ps...@on... - email


-- 
Thomas Sawyer
ps...@on... - email
(303) 285-3487 x1594 - voicemail/fax



---- Martin Lillepuu <ma...@li...> wrote:
> 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
> 
> 

__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com