Large databases in WebCat

This WebDNA talk-list message is from

1997

It keeps the original formatting. numero = 14448
interpreted = N
texte = Paul Uttermohlen wrote:> > >Grant Hulbert wrote:> >>> >> >The November 3 issue of InfoWorld reviews WebCatalog and WebMerchant on> >> >page 83.> >>> >> My only objection to the article is that they claim WebCatalog is not> >>good for large catalogs.> >> >I think you should repond strongly to this. I know the review was free> >advertising, but it is just this sort of ignorant, offhand remark that can> >pigeon-hole WC as a small database solution. It's amazing in light of how well> >the docs clarify WC as appropriate for large databases. Man, I get sick of> >flamin'> >> >Pat> > Ok, just how BIG of a catalog can one do with WebCat?> > PaulWe just hit over 100K items in our store being brought on-line. It cando in seconds what FileMaker simply can't do. We'll probably top outaround 200K. In terms of SKU's, it more than 100K items because manyitems have several options that will append the SKU value. In non-webdatabase terms, 10K is small, 100K is medium, and large is in themillions to Giga records range (think Amazon.com). I do, however, have some questions about RAM & cache settings forWebStar and WebCatalog. What settings are the most important forspeed? The actual inventory file is 20 Megs. There're other databasefiles such as details, options, etc. Also, are there ways of writing the search string to improve performance(ie put the most limiting field for the search first to drasticallyreduce records being compared for subsequent field criteria)?ThanksSandy Associated Messages, from the most recent to the oldest:

re: Large databases in WebCat (Grant Hulbert 1997)
Re: Large databases in WebCat (Grant Hulbert 1997)
Re: Large databases in WebCat (Sandra L. Pitner 1997)
Re: Large databases in WebCat (Sandra L. Pitner 1997)
re: Large databases in WebCat (Mark Rauterkus 1997)
Re: Large databases in WebCat (Grant Hulbert 1997)
re: Large databases in WebCat (Grant Hulbert 1997)
re: Large databases in WebCat (Bob Minor 1997)
Large databases in WebCat (Sandra L. Pitner 1997)

Paul Uttermohlen wrote:> > >Grant Hulbert wrote:> >>> >> >The November 3 issue of InfoWorld reviews WebCatalog and WebMerchant on> >> >page 83.> >>> >> My only objection to the article is that they claim WebCatalog is not> >>good for large catalogs.> >> >I think you should repond strongly to this. I know the review was free> >advertising, but it is just this sort of ignorant, offhand remark that can> >pigeon-hole WC as a small database solution. It's amazing in light of how well> >the docs clarify WC as appropriate for large databases. Man, I get sick of> >flamin'> >> >Pat> > Ok, just how BIG of a catalog can one do with WebCat?> > PaulWe just hit over 100K items in our store being brought on-line. It cando in seconds what FileMaker simply can't do. We'll probably top outaround 200K. In terms of SKU's, it more than 100K items because manyitems have several options that will append the SKU value. In non-webdatabase terms, 10K is small, 100K is medium, and large is in themillions to Giga records range (think Amazon.com). I do, however, have some questions about RAM & cache settings forWebStar and WebCatalog. What settings are the most important forspeed? The actual inventory file is 20 Megs. There're other databasefiles such as details, options, etc. Also, are there ways of writing the search string to improve performance(ie put the most limiting field for the search first to drasticallyreduce records being compared for subsequent field criteria)?ThanksSandy Sandra L. Pitner

DOWNLOAD WEBDNA NOW!

Large databases in WebCat

1997

Top Articles:

Related Readings: