Hi Steve, It could be the CAPTURING clause causing you grief.
Check the number of files in the UVTEMP directory. If there are a large number it could be that the OS is taking a long time to create the capturXXX file to store the results for the CAPTURING clause of the EXECUTE command. You could test this by removing the CAPTURING clause from the EXECUTE to see if it performs any better. If it does improve, and you are using the CAPTURING clause to hide the output of the select then look into the "HUSH ON|OFF" command. Regards, Gregor -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Long Sent: Wednesday, 15 June 2011 6:38 AM To: U2-Users@listserver.u2ug.org Subject: [U2] Strange Selection Behavior Hi All - I am getting strange results with selections that I am hoping someone else has encountered and can help me resolve. We have SB+ running on UV. I don't have the same issues running on Unidata. I have a BASIC program I have written that constructs a select statement based on the criteria specified in a screen by the user, then executes the constructed selection statement. Something like (although the real one is more complex): SEL.CMD = 'SELECT CUSTOMER WITH CUST.NUM = "' : CUST.NUM : '" AND WITH CUST.TYPE = "' : CUST.TYPE : '"' EXECUTE SEL.CMD CAPTURING OUTPUT Indexes are built on the dictionaries and are working properly. When we test the constructed select statement at TCL, the results are retuned under 2 seconds. When it executes inside the BASIC program, it takes approximately 24 seconds to return the same results. We tried adding a NO.INDEX to the statement, which adds 6 seconds to the select at TCL but just a couple of seconds within the BASIC program. Nothing else we have tried has had any effect. Has anyone encountered this type of behavior? Thanks, Steve Long Spyderweb Technical Services, Inc. (360) 687-8797 Washington (503) 406-8797 Oregon (866) 354-5913 Fax _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Message protected by DealerGuard: e-mail anti-virus, anti-spam and content filtering. http://www.pentanasolutions.com Click here to report this message as spam: https://login.mailguard.com.au/report/1CvNKu7Zp8/1yOzkbOV9fOILTpT5SHfdr/2.4 This email and any attachments to it are confidential. You must not use, disclose or act on the email if you are not the intended recipient. Liability limited by a scheme approved under Professional Standards Legislation. _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users