Re: Summary search -- speed
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 12136
interpreted = N
texte = >The summary search command appears very useful for pulling out unique fields, >such as the categories in the Tea Room example that ships with 2.0. > >I'm wondering what type of speed this summary search command has over large >databases. If the inventory was in the 100K records range, would there be a >significant speed hit for a unique entry summary search?A search on a smaller database is always faster, but it may not be noticeable in WebCat2 because it's already so fast. Maybe the number if different categories would be the speed-limiting factor in this case, I don't know. But the fastest solution will be a separate database, that's for sure.>Would I be better off >with a separate data table that kept a unique list of categories, etc?Yes, of course, especially since it seems you already have the basic understanding that planning is the most important part of creating an extendable WebCat2-based service.>I don't yet have the large inventory database to play with, but I need to plan >ahead for it.If you create a separate database that has all your categories in it, then you won't ever have to worry about this again. Write your WebDNA properly, and this technique gives you the added advantage of restricting the categories entered in the large database to only the ones you have previously entered into the smaller 'category.db' file.Popup lists created from a search on your category.db are a great way to implement this feature ... :)Sincerely, Ken Grome WebDNA Solutions
Associated Messages, from the most recent to the oldest:
>The summary search command appears very useful for pulling out unique fields, >such as the categories in the Tea Room example that ships with 2.0. > >I'm wondering what type of speed this summary search command has over large >databases. If the inventory was in the 100K records range, would there be a >significant speed hit for a unique entry summary search?A search on a smaller database is always faster, but it may not be noticeable in WebCat2 because it's already so fast. Maybe the number if different categories would be the speed-limiting factor in this case, I don't know. But the fastest solution will be a separate database, that's for sure.>Would I be better off >with a separate data table that kept a unique list of categories, etc?Yes, of course, especially since it seems you already have the basic understanding that planning is the most important part of creating an extendable WebCat2-based service.>I don't yet have the large inventory database to play with, but I need to plan >ahead for it.If you create a separate database that has all your categories in it, then you won't ever have to worry about this again. Write your WebDNA properly, and this technique gives you the added advantage of restricting the categories entered in the large database to only the ones you have previously entered into the smaller 'category.db' file.Popup lists created from a search on your category.db are a great way to implement this feature ... :)Sincerely, Ken Grome WebDNA Solutions
Kenneth Grome
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:
RE: Writefile outside WebSTAR hierarchy? (1997)
Interfacing WC with mail server (1998)
Formulas.db + Users.db (1997)
Pithy questions on webcommerce & siteedit (1997)
Help name our technology! I found it (1997)
Date format problems (1997)
[WebDNA] A new popuated field to a DB with 700.000 records (2009)
[WebDNA] can webdna set the email header (w/[sendmail]) that (2012)
authenticate and password (1998)
Apple event reply error (-1) (1997)
Tab Charactor (1997)
Stymied by [ShowNext] with drop down list on a form (1998)
b12 cannot limit records returned and more. (1997)
showif and cart (1997)
WebCat2b15MacPlugin - [protect] (1997)
Re[3]: 2nd WebCatalog2 Feature Request (1996)
Hiding HTML and page breaks (1997)
Cart Question (1998)
Setting the Date (2000)
[WebDNA] Wishlist: ignore whitespace in database changes (2016)