I'm not sure if the whole effect is explained by AIX's file caching, but accessing RAM is on the order of 1000 times faster than disk reads. This becomes even more pronounced if files are poorly sized. Date: Tue, 4 Sep 2012 07:49:09 -0700 From: [email protected] To: [email protected] Subject: Re: Strange COUNT/SELECT behavior on AIX
I have looked at this and approved it. The question is mostly a jBASE issue and as such does belong here. Rick On Tuesday, September 4, 2012 9:13:28 AM UTC-4, vivek wrote:No T24 in this group please On Tuesday, 4 September 2012, DD 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 ~ -->dateTue Aug 21 15:23:59 METDST 2012 jsh t24adm ~ -->COUNT FBNK.RE.CONSOL.SPEC.ENTRY12482387 Records counted jsh t24adm ~ -->dateTue 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 countedusr: 11.51 sys: 14.82 elapsed: 47m33.02s jsh t24adm ~ -->dateTue 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 -- -- Vivek -- -- 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
