Re: How does WebCatalog search the database?

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 15476
interpreted = N
texte = Per:WebCatalog's speed comes from caching data in RAM and making other itelligent choices about how to access the information. Indexing can speed up a particular search, but doesn't necessarily help in the general case. It's good when you store most of your data on disk and don't want to read it very often. WebCatalog has an incredibly flexible search function that works well no matter how it's used. It works very well on VERY large databases: that is it's primary advantage over a lot of other solutions. We have use it many times on multi-100,000 record databases and some of our customers use it on larger ones. I hope this helps.John.>Im a newbie to WebCatalog and this list, so excuse me if Im asking the >obvious... > >But my question is: How does WebCatalog search its data? >As it uses a flat file databases one should expect it to do a search >through the entire file before returning the matching data. This is, as I >understand it, not a good way if the database contains _many_ records. So >my questin is: does WebCatalog index the data when it loads a database into >memory? If not, hos does WebCatalog perform when it comes to BIG databases? > >Hope someone can answer me on this :) > >Per Christian Lied, >pk@pluto.wit.no John A. Hill Pacific Coast Software http://www.smithmicro.com Associated Messages, from the most recent to the oldest:

    
  1. Re: How does WebCatalog search the database? (Kenneth Grome 1997)
  2. Re: How does WebCatalog search the database? (John Hill 1997)
  3. How does WebCatalog search the database? (Per Christian Lied 1997)
Per:WebCatalog's speed comes from caching data in RAM and making other itelligent choices about how to access the information. Indexing can speed up a particular search, but doesn't necessarily help in the general case. It's good when you store most of your data on disk and don't want to read it very often. WebCatalog has an incredibly flexible search function that works well no matter how it's used. It works very well on VERY large databases: that is it's primary advantage over a lot of other solutions. We have use it many times on multi-100,000 record databases and some of our customers use it on larger ones. I hope this helps.John.>Im a newbie to WebCatalog and this list, so excuse me if Im asking the >obvious... > >But my question is: How does WebCatalog search its data? >As it uses a flat file databases one should expect it to do a search >through the entire file before returning the matching data. This is, as I >understand it, not a good way if the database contains _many_ records. So >my questin is: does WebCatalog index the data when it loads a database into >memory? If not, hos does WebCatalog perform when it comes to BIG databases? > >Hope someone can answer me on this :) > >Per Christian Lied, >pk@pluto.wit.no John A. Hill Pacific Coast Software http://www.smithmicro.com John Hill

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:

Navigator Parsing (1997) writing db to disk (1997) WebCat2b15MacPlugin - showing [math] (1997) show all problem (1997) price carry over (1997) Help formatting search results w/ table (1997) Post (1997) Refering page (1998) Multiply prices (1997) authnet good news (2003) Pithy questions on webcommerce & siteedit (1997) WebCat2b12plugin - [search] is broken ... not! (1997) Protect vs Authenicate (1997) Re:2nd WebCatalog2 Feature Request (1996) shipcost (1997) More on the email templates (1997) Three new problems, maybe a fourth (1997) FW: Virus Alert: FBI Finds 911 Virus Wiping Out Hard Drives Today (2000) WebCat (or other) Indexing (1999) OSX Dev Server? (2004)