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:
Summing fields (1997)
Any way to retrieve information from clipboard? (1998)
Comments in db? (1997)
Cart questions (1997)
WebCat2b13MacPlugIn - syntax to convert date (1997)
PCS Frames (1997)
Shipping formula problem (1997)
Using Applescript to process WebCatalog functions (1998)
PCS Frames (1997)
code to phantom spacing (2001)
default value from Lookup (was Grant, please help me) (1997)
What about an ends with operator? (2000)
[WebDNA] Suddenly, lots of WebDNA problems with FastCGI (2013)
WebCat2b13MacPlugIn - More limits on [include] (1997)
search form problem.. (1997)
[OT] SSL (2003)
WebCat editing, SiteGuard & SiteEdit (1997)
WebTEN vs webSTAR (1998)
os x server (2000)
WebCatalog [FoundItems] Problem - LONG - (1997)