Re: Item availability

["Christian J. Müller" <cmueller@polinet.ch>]

I have implemented an inventory check. I do not think that it would
substantially reduce performance, since the check is only performed on
the items presented by the results page. If you have unique items, then
you could further improve performance by periodically running a script
that removes items with 0 quantity from the products database.
 
Chris

dbw wrote:
> 
> ******    message to minivend-users from "dbw" <dbw@deepblueworld.com>     ******
> 
> I was thinking something along those lines, but checking in the actual
> inventory database, but I was thinking that there might be a better way to
> do it such that I don't have to do a query on every item that could be
> displayed.  Maybe something like an "active" vs. "inactive" inventory item.
> I guess I was secretly hoping that such a thing already exists...
> 
> Do you think that doing something like this will generate a huge performance
> hit?  If, for example, I do a search that results in 30 items being
> returned, and then before I display each item I hit the database again to
> validate item quantity, I am concerned that this is not so scalable.
> 
> Thanks for you input!
> Patrick
> ----- Original Message -----
> From: Hans-Joachim Leidinger <hans-joachim.leidinger@home.gelsen-net.de>
> To: <minivend-users@minivend.com>
> Sent: Wednesday, August 18, 1999 12:33 PM
> Subject: Re: Item availability
> 
> > ******    message to minivend-users from Hans-Joachim Leidinger
> <hans-joachim.leidinger@home.gelsen-net.de>     ******
> >
> > Hi Patrick,
> >
> > if you have a field like "quantity" in your products.asc file you can
> > use
> >
> > [if-field quantity]
> > the whole stuff to display item
> > [if-field]
> >
> > This is my idea and not tested.
> >
> > Joachim
> >
> > > dbw wrote:
> > >
> > > Has anyone implemented or thought about implementing a check on item
> > > quanity such that if an item has a quantity of 0, that item is no
> > > longer displayed is search results or inventory browses, category
> > > searches, etc..?
> > >
> > > We are working on a project that has unique pieces, some of them one
> > > of a kind, and we need to put something like this into place.
> > >
> > > Any ideas, questions, or snide remarks would be greatly appreciated.
> > >
> > > Thanks very much,
> > >
> > > Patrick Glennon
> > >
> >
> > --
> > -------------Hans-Joachim Leidinger---------------------
> >
> >
> > -
> > To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
> > email with 'UNSUBSCRIBE minivend-users' in the body to
> Majordomo@minivend.com.
> > Archive of past messages: http://www.minivend.com/minivend/minivend-list
> >
> 
> -
> To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
> email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
> Archive of past messages: http://www.minivend.com/minivend/minivend-list