The second COUNT finished at the same time because the file was already in memory from the first COUNT.
Dan On Tue, Sep 4, 2012 at 4:57 AM, DD <[email protected]> wrote: > Dear all, > > We are migrating our application (T24) on jBASE from HP-UX to AIX. We are > experiencing some strange behavior of SELECT (and COUNT) on large files > (JPlus, >2GB). Apart from being slower on AIX (which may have to do with > SAN), there is something else that I cannot explain. > > If I start the same COUNT from different ssh sessions, all finish at > exactly the same time: > > jsh t24adm ~ -->date > Tue Aug 21 15:23:59 METDST 2012 > jsh t24adm ~ -->COUNT FBNK.RE.CONSOL.SPEC.ENTRY > > 12482387 Records counted > > jsh t24adm ~ -->date > Tue Aug 21 *17:46:16* METDST 2012 > > The above process took almost 2,5 hours. The below one I started much > later on the same environment from another session, but they came back at > the very same second: > > jsh t24adm ~ -->time COUNT FBNK.RE.CONSOL.SPEC.ENTRY > > 12482403 Records counted > > usr: 11.51 sys: 14.82 elapsed: 47m33.02s > jsh t24adm ~ -->date > Tue Aug 21 *17:46:16* METDST 2012 > > This is not a coincidence, I saw it many times. > Any ideas? > > -- > -- > IMPORTANT: T24/Globus posts are no longer accepted on this forum. > > To post, send email to [email protected] > To unsubscribe, send email to [email protected] > For more options, visit this group at > http://groups.google.com/group/jBASE?hl=en > > > > -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
