Re: How is it done?
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17459
interpreted = N
texte = >>Also, searching by date can be slow because so >>much interpretation is required of mm/dd/yyyy fields. You can get as much >>as a 10x improvement on date searches if you reformat them to be >>text-sortable as yyyymmdd. > >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? > >After all, the number of days since 1900 format results in a value that >is exactly 6-digits long, at least for the next 700 years or so ... which >is far greater a date range than I will ever need. We changed our dates to this format and saw a huge difference in the speed of the search.The problem with using the yyyymmdd is dealing with date math. If you tried to get WebCat to find the difference between 19981231 and 19990101, it would give you 8870, not 1.--- Trevor Crist Digital Frontier Stowe, Vermont 802.253.8612 http://www.digitalfrontier.com
Associated Messages, from the most recent to the oldest:
>>Also, searching by date can be slow because so >>much interpretation is required of mm/dd/yyyy fields. You can get as much >>as a 10x improvement on date searches if you reformat them to be >>text-sortable as yyyymmdd. > >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? > >After all, the number of days since 1900 format results in a value that >is exactly 6-digits long, at least for the next 700 years or so ... which >is far greater a date range than I will ever need. We changed our dates to this format and saw a huge difference in the speed of the search.The problem with using the yyyymmdd is dealing with date math. If you tried to get WebCat to find the difference between 19981231 and 19990101, it would give you 8870, not 1.--- Trevor Crist Digital Frontier Stowe, Vermont 802.253.8612 http://www.digitalfrontier.com
Trevor Crist
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:
Hideif on IP range (2004)
WebCat on Linux (2000)
Integration with SQL (1997)
hyperlinking unique input strings on the fly when displaying in HTML (2000)
Is there an alternative to emailer? (1999)
[WebDNA] ENCRYPTION problems (2012)
help testing quicktime delivery (1997)
taxTotal, grandTotal (1997)
SQL/ODBC (again) (2004)
[authenticate] (1999)
jpg and gif format thumbnails (2004)
Generating Report Totals (1997)
Searching multiple fields from one form field (1997)
relogin same user? (1998)
WebCat2.0 [format thousands .0f] no go (1997)
checking for [ and ] in form fields ... (1997)
page chokes on hideif when false and ignored (1998)
Cart Already Submitted (2003)
Server Freeze (1998)
Size limit for tmpl editor ? (1997)