Re: [lookup] speed sales pitch
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 53531
interpreted = N
texte = >2. WebCat databases work well, even when they get big, but can get >bogged down with doing date searches, and number searches to a >lesser extent, since the data must be interpreted then compared. This is why I have always been a proponent of storing dates as "days since 0000" because then you can do a simple text search on a date field and it doesn't bog down. This works great for dates that create a "days since 0000" value of 6 digits, which includes dates in anyone's current lifetime. But if you are using a date range that does not create a 6-digit string - such as dates far in the past or a long time in the future - then you would need to do a mathematical comparison of the "days since 0000" value, which is still less overhead than interpreting date stored as formatted MM/DD/YYYY values. -- Sincerely, Kenneth Grome ------------------------------------------------------------- Outsource your WebDNA programming for $18 an hour or less! ------------------------------------------------------------- ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>2. WebCat databases work well, even when they get big, but can get >bogged down with doing date searches, and number searches to a >lesser extent, since the data must be interpreted then compared. This is why I have always been a proponent of storing dates as "days since 0000" because then you can do a simple text search on a date field and it doesn't bog down. This works great for dates that create a "days since 0000" value of 6 digits, which includes dates in anyone's current lifetime. But if you are using a date range that does not create a 6-digit string - such as dates far in the past or a long time in the future - then you would need to do a mathematical comparison of the "days since 0000" value, which is still less overhead than interpreting date stored as formatted MM/DD/YYYY values. -- Sincerely, Kenneth Grome ------------------------------------------------------------- Outsource your WebDNA programming for $18 an hour or less! ------------------------------------------------------------- ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
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:
Num Sort Descending (2004)
Quick ShowIf question (1997)
Printing a final order (1997)
no global [username] or [password] displayed ... (1997)
Help name our technology! I found it (1997)
Forms Search Questions (1997)
[WebDNA] OT: How is this being done? Curious. (2009)
Creating main- and sub-category search (1997)
Big Databases (1997)
Bug Report, maybe (1997)
Smith Micro - no competition (2000)
Multiple security dbs (1997)
RE: Checkboxes to add to cart... (1998)
RED QUESTION MARKS AGAIN (1999)
[WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (2009)
Sendmail Context (2003)
unable to launch acgi in WebCat (1997)
DON'T use old cart file! (1997)
Sort Issue? (2000)
Bad Cookie / Internet Option / Internet Explorer (2004)