Re: Performance using dates with SQL or RPG

["Peter Dow" <pcdow@xxxxxxxxx>]

Hi Jon,

I thought the tone of the article was more asking the question why is RPG so
slow with date fields when other languages are not, than saying don't use
date fields.  At least that's the question I got out of it.

Regards,
Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax


----- Original Message -----
From: <Jon.Paris@hal.it>
To: <RPG400-L@midrange.com>
Sent: Monday, April 23, 2001 12:13 PM
Subject: Re: Performance using dates with SQL or RPG


>
>  >> I read an article about performance using files with date/timestamps
> fields
>
> In my opinion I've only ever read one article on the use of dates that
made
> any sense at all and that was also published by Midrange back in '98? - it
> was by Pence and Hawkins - sorry I can't find an actual date reference for
> you.  They explained the whole thing including the performance aspects.
>
> In my opinion the article you referenced, along with others that went
> before it, completely misses the point (not to mention problems in other
> areas).
>
> Yes - it takes longer to read a file containing dates.  How much longer?
> Well how long does it take you to recover from a batch run that failed due
> to an invalid date on the file?  Won't happen when using dates! How much
> longer did all of your other programs take to run when they used numerics
> and the dates had to be validated and edited every time you input to
output
> them.  How long did it take you to explain to a user how to formulate a
> query in an end-user reporting tool to handle date ranges on an MDY date.
> etc. etc. etc.
>
> Ignore this article - you did the right thing in using dates - if you have
> a performance issue with specific batch programs it can normally be dealt
> with by coding logical that excludes the date fields or presents them as
> numerics (Pence and Hawkins covered this in one of their date related
> pieces).
>
>
> As I said - my opinion - others mileage may vary!
>
>
> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to RPG400-L@midrange.com.
> | To subscribe to this list send email to RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---