Outside India, I doubt that too many people know what a lakh is! J
However, why are you using SSELECT here? It will be a lot slower than SELECT I suspect, especially when you come to use the list afterwards. I think that you have just created a huge query without any indexes and lots of conditions and it is going to take a long time to do that. Create some indexes to help this. Maybe on CO.CODE for instance. Jim From: [email protected] [mailto:[email protected]] On Behalf Of Ramkumar Sreeni Sent: Thursday, November 11, 2010 3:46 AM To: [email protected] Subject: T24: Select on local template - performance issue Hi All, We created a report which will list the FT transactions that are with TRANSACTION.TYPE LK OT..., for outward remittance report, so we created a local template which will have the list of FT id's from the history file and also fields which will store information like TRANSACTION.TYPE, CO.CODE and 9 more fields as these fields are the same fields that will appear in the enquiry dynamic select criteria, when we run the enquiry, internally the enquiry is running a select criteria as shown in the mw42 jbase monitor SSELECT F.FT.BMITPL.OTPASTS WITH TRANSACTION.TYPE LIKE OT... AND CO.CODE EQ BH0010001 etc The above select query is taking more time and the browser enquiry is timing out, since the local template has 3 lakh records. Please suggest me a suitable solution so as to avoid browser enquiry getting timed out. Regards, Ramkumar.S -- Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 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 -- Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 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
