Re: Big Databases

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 11527
interpreted = N
texte = >Can I get some guidance on the practical limits for WebCat handling large >databases? I have a client who wants to do a CustomerID lookup from about a >100,000 record Customer database and if a match is found to return the >customer info (name address etc) to the order entry form.Depending on how you tune the search, this can be very fast. On a slow machine, a [lookup] in a 10,000 record database takes about 1/100 second. That is probably the fastest-case search. More complex searches (case-insensitive, multi-word, etc) take longer. I'm guessing your CustomerID is exact, so you can probably take advantage of the faster lookup function.We have customers with 189,000 and 250,000 record databases. I believe they have reported 3-second search times for full-text case-insensitive multi-word (in other words, worst case) scenarios. [lookup] would be much faster.If your client can pay for some customization, we can provide much faster speeds by tuning WebCatalog for his particular case.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com Associated Messages, from the most recent to the oldest:

    
  1. Re: Big Databases (Marty Schmid 1997)
  2. Re: Big Databases (Grant Hulbert 1997)
  3. Re: Big Databases (Kenneth Grome 1997)
  4. Big Databases (Marty Schmid 1997)
>Can I get some guidance on the practical limits for WebCat handling large >databases? I have a client who wants to do a CustomerID lookup from about a >100,000 record Customer database and if a match is found to return the >customer info (name address etc) to the order entry form.Depending on how you tune the search, this can be very fast. On a slow machine, a [lookup] in a 10,000 record database takes about 1/100 second. That is probably the fastest-case search. More complex searches (case-insensitive, multi-word, etc) take longer. I'm guessing your CustomerID is exact, so you can probably take advantage of the faster lookup function.We have customers with 189,000 and 250,000 record databases. I believe they have reported 3-second search times for full-text case-insensitive multi-word (in other words, worst case) scenarios. [lookup] would be much faster.If your client can pay for some customization, we can provide much faster speeds by tuning WebCatalog for his particular case.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com Grant Hulbert

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:

Canadian WebDNA host wanted (2004) WebDNA on Redhat (2008) [HIDEIF] inside [FOUNDITEM] (1997) delete some html code (2007) Server crash (1997) Upload and WebCat (1998) Configuring E-mail (1997) RAM variables (1997) Nested tags count question (1997) Mystery authentication (1997) More on EudoraPro Email (1998) ReturnRaw and redirect (1997) Dark Horse Comics success story (1997) Multiple security dbs (1997) date formatting for CC card expiration date check (1998) Max Record length (1997) converchars in sendmail context.... (2004) RE: Migrating to NT (1997) Not really WebCat (1997) NT License trade for Mac (2000)