Re: How is it done?
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17465
interpreted = N
texte = >I can see where this particular format would make searching faster, but >what about re-formatting my dates as the number of days since 1900? >Wouldn't that make searching even faster yet?Yes, but only if you make sure the numbers are 0-filled and fixed-width, so they can still be compared as text. Something like [format .6d]1[/format], which yields 000001.>You mentioned that storing dates in text-sortable format can yield a 10x >improvement on search times. Wouldn't a *numeric* search be even faster >than a text-based search?No, text is faster. It takes a small amount of time to convert text to numbers.>Does using the rn parameter in a search like this require that we also >put FieldNameType=num into the search parameters?Yes, ranges actually do work for numbers and dates (and text), but you have to tell it what type they are, just as you would for sorting. For a text range, E is in between C and K.Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>I can see where this particular format would make searching faster, but >what about re-formatting my dates as the number of days since 1900? >Wouldn't that make searching even faster yet?Yes, but only if you make sure the numbers are 0-filled and fixed-width, so they can still be compared as text. Something like [format .6d]1[/format], which yields 000001.>You mentioned that storing dates in text-sortable format can yield a 10x >improvement on search times. Wouldn't a *numeric* search be even faster >than a text-based search?No, text is faster. It takes a small amount of time to convert text to numbers.>Does using the rn parameter in a search like this require that we also >put FieldNameType=num into the search parameters?Yes, ranges actually do work for numbers and dates (and text), but you have to tell it what type they are, just as you would for sorting. For a text range, E is in between C and K.Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
PCS Technical Support
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:
WebCat2b15MacPlugin - [protect] (1997)
Error: the 'showcart' command requires that you specify a db (1997)
converted seed value? (1998)
Custom error files (1998)
RE: New WebCatalog Version !!! (1997)
Looking for WebCatalog Programmer in Silicon Valley (1998)
WebDNA on RedHat ES 4 (2007)
RE: [WebDNA] Basic Search (2008)
Emailer Q (2002)
frames & carts (1997)
WebCat2b15MacPlugin - showing [math] (1997)
Where can I get 'ssh'? (was: WebCatalog on Linux/MacOSX/etc) (2000)
Re:Help name our technology! (1997)
FW: It gets better... posting problems + Webcat 3.0.7 avail able - did anyone know? (2000)
webcat- multiple selection in input field (1997)
Date sorting (1997)
WebCat B13 Mac CGI -- Frames question (1997)
Anyone get webdna to run on apache 2.x on osx? (2006)
Help! WebCat2 bug (1997)
2.1b3 --> way slow (1997)