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 Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net Associated Messages, from the most recent to the oldest:

    
  1. Re: Sort of a Dilema! (Kenneth Grome 1998)
  2. Re: Sort of a Dilema! (Terry Wilson 1998)
  3. Re: Sort of a Dilema! (Dave MacLeay 1998)
  4. Sort of a Dilema! (The Mooseman 1998)
>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 Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://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:

HELP WITH DATES (1997) Search Form (2000) Associative lookup style? (1997) [random] only for 1-100??? (1997) wierd [cart] action! (1997) emailer w/F2 (1997) Share Bulletin Board? (1998) [isfile] ? (1997) assigning a id no. (2000) [WebDNA] New Webdna framework ! (2012) Error Page? (1997) Wanted: Broader string manipulation functions (1997) Multiple Passwords (1997) One more try (1997) Apache2 connector (2003) Just a thought (1998) Max Record length restated as maybe bug (1997) Tip: upgrading to WebCatalog 3.x, fields to watch for (1999) WebCat2_Mac RETURNs in .db (1997) Error 11 (1996)