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? > > Paul We just hit over 100K items in our store being brought on-line. It can do in seconds what FileMaker simply can't do. We'll probably top out around 200K. In terms of SKU's, it more than 100K items because many items have several options that will append the SKU value. In non-web database terms, 10K is small, 100K is medium, and large is in the millions to Giga records range (think Amazon.com). I do, however, have some questions about RAM & cache settings for WebStar and WebCatalog. What settings are the most important for speed? The actual inventory file is 20 Megs. There're other database files 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 drastically reduce records being compared for subsequent field criteria)?ThanksSandy
Associated Messages, from the most recent to the oldest:
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? > > Paul We just hit over 100K items in our store being brought on-line. It can do in seconds what FileMaker simply can't do. We'll probably top out around 200K. In terms of SKU's, it more than 100K items because many items have several options that will append the SKU value. In non-web database terms, 10K is small, 100K is medium, and large is in the millions to Giga records range (think Amazon.com). I do, however, have some questions about RAM & cache settings for WebStar and WebCatalog. What settings are the most important for speed? The actual inventory file is 20 Megs. There're other database files 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 drastically reduce records being compared for subsequent field criteria)?ThanksSandy
Sandra L. Pitner
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Summary search -- speed (1997)
E-mail Attachments (1997)
WebCatalog for Mac 2.0.1 Released (1997)
stray LF character in the email (2003)
Signal Raised Error (1997)
Word wrapping (1997)
Emailer errors & disappearing messages (1998)
Max Record length restated as maybe bug (1997)
WebCat2b13MacPlugIn - syntax to convert date (1997)
Re1000002: Setting up shop (1997)
test - ignore please (2003)
Not really WebCat - need HTML Grider (1997)
sort without the or a (1998)
using webdna to determine pixel parameters (2000)
WebCatalog can't find database (1997)
Bug Report, maybe (1997)
WebCatalog2 Feature Feedback (1996)
PROBLEMS WITH PROTECT TAG (2004)
WebCatalog on Solaris? (2000)
Tea Room trouble (1997)