×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
My guess would be that the overhead would come when using the %date() bif
for working with the date data if you need to be comparing back and forth
between decimal and pure dates. I've read that %date() has significant
overhead. Can't remember where I read it now, it is just something that I
seem to *remember*. So if this isn't true, someone please correct me...
I use %date() a lot because our db is decimal dates and I refuse to date
processing without using native %date() bifs :D Its so much cleaner.
Thanks
Bryce Martin
Programmer/Analyst I
570-546-4777
David Gibbs <david@xxxxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
03/16/2010 02:22 PM
Please respond to
RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
To
RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
cc
Subject
Re: Timestamp vs Date/time Decimal fields, Overhead in RPG programs...
George Lopez wrote:
From what I heard from Bob Cozzi years many years ago there is a
disadvantage using timestamp field in physical file instead of the
tried and true date and time decimal fields in terms of speed if you are
doing mass update of those fields in an RPG progam? Or is that not
true anymore?
Although I don't have any empirical evidence ... my gut says that the
overhead is no longer a significant factor.
david
midrange.com
