Re: Search design
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 11289
interpreted = N
texte = >I assume when you say it scales linearly, you are referring to # of records in >inventory table ? Any idea at when it begins to bog down?By linear I mean it never 'bogs down' suddenly at some point. It's just what you'd expect -- the more records and more complex the search is, the slower it gets.[Lookup], for instance is an extremely fast special-case search: it is case-sensitive and looks for exact match only. So it can look thru 10,000 records in about 1/100 of a second.You may get up to a few seconds on complex searches thru 100,000 records with lots of text.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court, #453 | 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:
>I assume when you say it scales linearly, you are referring to # of records in >inventory table ? Any idea at when it begins to bog down?By linear I mean it never 'bogs down' suddenly at some point. It's just what you'd expect -- the more records and more complex the search is, the slower it gets.
[lookup], for instance is an extremely fast special-case search: it is case-sensitive and looks for exact match only. So it can look thru 10,000 records in about 1/100 of a second.You may get up to a few seconds on complex searches thru 100,000 records with lots of text.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court, #453 | 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:
WebCatb15 Mac CGI -- [purchase] (1997)
webcat NT (1998)
[WebDNA] uploading videos (2018)
Upgrading old WebCat Database Files (1997)
Forms Search Questions (1997)
Sandbox DB permissions (2005)
Extended [ConvertChars] (1997)
[WriteFile] problems (1997)
Protect (1997)
search between two dates (2003)
cookies (2002)
[format 40s]text[/format] doesn't work (1997)
External Images (1998)
syntax question, not in online refernce (1997)
WCS Newbie question (1997)
Listserver problem (1997)
suffix mapping for NT? (1997)
Emailer help....! (1997)
Show Databases in admin (2000)
using showpage and showcart commands (1996)