Re: [SQL-Ledger-users] LARGE INVENTORY

[<tra...@ya...>]

   I think it would be better to slice this huge page in pages of n
elements and then display just n elements and give to the user a next
page link or button so we will just be selecting from the DB all the
elements but the heavy operation that is generating the page will be
done with a subset of all the elements. But in this case we should
keep the state of the module, I mean the "next page" will mean
different places every time we show it. So we could put that
information in the "next page" link, we could include the query
parameters and the next starting ID for the next page, and the same
for "prev page" . Do I explain my self?

Claudio Santana.

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


_________________________________________________________
Do You Yahoo!?
Obtenga su dirección de correo-e gratis @yahoo.com
en http://correo.espanol.yahoo.com