Re: date format (another question)
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 26798
interpreted = N
texte = >I still am conflicted about using the different methods because they each >seem to have advantages and disadvantages. That's why Bob's suggestion makes the most sense -- use both. Better yet, suse my techinqie in one forls, and use 3 additional fields -- MM, DD and YYYY. Add a Weekday field too if you have to search by day of the week.>I think an answer to the performance question might sway things, but >I suspect that the performance hit is minimal.It is probably best if you do not make assumptions like this. I have proven this issue to be so serious -- in some situations -- as to make webcat totally useless for all practical purposes.If you want to prove it yourself, try searching a 700,000-record db, each record having a mm/dd/yyyy formatted date value. Do your search for a date occurring in between the two date values in your search context. You'll see that performance slows to a crawl -- with only ONE HIT to the server in a test environment. Now multiply that dozens of times to simulate a busy website in the real world, then tell me the performance hit is 'minimal' ...Th fact is, the performance hit is *huge* when you have hundreds of thousands of records with formatted date values in them, and it is compounded when you have a busy website. I would not have developed my days since 0000 date storage/searching techniques if webcat could have handled it otherwise ...================================ Kenneth Grome, WebDNA Consultant 808-737-6499, http://webdna.net ================================------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to
.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
Associated Messages, from the most recent to the oldest:
>I still am conflicted about using the different methods because they each >seem to have advantages and disadvantages. That's why Bob's suggestion makes the most sense -- use both. Better yet, suse my techinqie in one forls, and use 3 additional fields -- MM, DD and YYYY. Add a Weekday field too if you have to search by day of the week.>I think an answer to the performance question might sway things, but >I suspect that the performance hit is minimal.It is probably best if you do not make assumptions like this. I have proven this issue to be so serious -- in some situations -- as to make webcat totally useless for all practical purposes.If you want to prove it yourself, try searching a 700,000-record db, each record having a mm/dd/yyyy formatted date value. Do your search for a date occurring in between the two date values in your search context. You'll see that performance slows to a crawl -- with only ONE HIT to the server in a test environment. Now multiply that dozens of times to simulate a busy website in the real world, then tell me the performance hit is 'minimal' ...Th fact is, the performance hit is *huge* when you have hundreds of thousands of records with formatted date values in them, and it is compounded when you have a busy website. I would not have developed my days since 0000 date storage/searching techniques if webcat could have handled it otherwise ...================================ Kenneth Grome, WebDNA Consultant 808-737-6499, http://webdna.net ================================------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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
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:
Search in 2 or more catalogs (1997)
CAPTCHA system in webDNA (2005)
Bug Report, maybe (1997)
can WC render sites out? (1997)
[WebDNA] Commas within table content (2009)
Hiding HTML and page breaks (1997)
Code database (1998)
Now you see it now you donīt (1997)
Javascript and Search Results (1998)
SiteGuard Admin Feature ? (1997)
Avery 5160 Mailing Labels (2003)
WebCat2b13MacPlugIn - More limits on [include] (1997)
Problems with [Search] param - Mac Plugin b15 (1997)
TRAINING videos - Prove IT. (1998)
Emailer setup (1997)
Problem displaying search result (1997)
HomePage Caution (1997)
[OT] (waaaay OT) (2004)
More on the email templates (1997)
Colocator Upgrading OS (2004)