The first pass on a file has to start from scratch. Once it has been read and is still fresh in memory, a 2nd pass will run much faster.
John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Kebbon Irwin Sent: Thursday, July 30, 2009 10:58 AM To: [email protected] Subject: [U2] Slow selects We are running Unidata 7.1 on a linux box (Red Hat Enterprise Linux ES release 4 (Nahant Update 4) Kernel 2.6.9-42.ELsmp on an i686). For some reason I cannot fathom, the first time you perform any Uniquery command on a file it takes forever to return. Say, 5 minutes. Subsequent queries on the same file, with different criteria (or the same), take seconds, say 10. This is generally on static, hashed files with lots of level 1 overflow, but no level 2 overflow. This is a pretty fast environment with this weird exception. Any ideas about what the problem might be? Thanks, Kebbon _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
