Re: Sort of a Dilema!
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 18410
interpreted = N
texte = >These formats (especially the number of days since>00/00/0000) are also easier for WebCat to parse, so>your searches will become a little speedier.Storing and comparing dates as the number of days since 00/00/0000 is a *LOT* speedier if you're doing any kind of date comparisons in your searches, especially when you have a large database.I switched from storing dates in the default format to storing dates as the number of days since 00/00/0000, and it has made my large database searches speed up by more than 10,000% -- and that's no exaggeration whatsoever, in fact, it's a very conservative guess. The real results are that a date comparison search that used to run for hours without results now takes just seconds!By the way, since I have changed all the WebDNA code in several different sites to deal with dates as the number of days since 00/00/0000, I wrote a handy web date reference page, and I made it available for everyone else to use. It's downloadable as a .sit file (for use on your own WebDNA site) at:http://webdna.net/dates.sitor it's available as an online reference page at:http://webdna.net/dates.htmlEither way, it's worth taking a look at ... :)Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Associated Messages, from the most recent to the oldest:
>These formats (especially the number of days since>00/00/0000) are also easier for WebCat to parse, so>your searches will become a little speedier.Storing and comparing dates as the number of days since 00/00/0000 is a *LOT* speedier if you're doing any kind of date comparisons in your searches, especially when you have a large database.I switched from storing dates in the default format to storing dates as the number of days since 00/00/0000, and it has made my large database searches speed up by more than 10,000% -- and that's no exaggeration whatsoever, in fact, it's a very conservative guess. The real results are that a date comparison search that used to run for hours without results now takes just seconds!By the way, since I have changed all the WebDNA code in several different sites to deal with dates as the number of days since 00/00/0000, I wrote a handy web date reference page, and I made it available for everyone else to use. It's downloadable as a .sit file (for use on your own WebDNA site) at:http://webdna.net/dates.sitor it's available as an online reference page at:http://webdna.net/dates.htmlEither way, it's worth taking a look at ... :)Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
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:
Passing Variables to a [shell scriptid=123][/shell] context (2004)
Users.db (1998)
[WebDNA] Downloading and combining RSS feeds (2012)
HTML Editors (1997)
Deleting Multiple Database Records based on Checkbox (1998)
Non-Cart Files in Shopping Cart Folder (1997)
problems with 2 tags (1997)
Cookie still not working (1999)
Problems searching from a FORM (1997)
Browser Problem?!? Still getting Error message usingPOST! (1997)
WebCat2b13MacPlugIn - More limits on [include] (1997)
Digest Version (2000)
Sorting by date (1997)
Free WebDNA snippets (Extending WebCatalog) (1997)
[cart]'s ever get recycled? (2000)
No Data Results (1997)
this year (2000)
Fun with Dates - finally resolved but.... (1997)
Webcatalog error, Plug-in for Webstar (1996)
WebCat and WebTV (1997)