Thanks Dan, I thought so, but does that mean that most of this time (2+ hours) the file is loading into memory, and the actual COUNT takes a fraction of a second? So the second session does nothing but waits for the loading completion, and then fires the COUNT result?
On Tuesday, September 4, 2012 12:03:42 PM UTC+2, Daniel Klein wrote: > > 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] <javascript:>>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] <javascript:> >> To unsubscribe, send email to [email protected] <javascript:> >> 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
