send me the query madam will tell u the easiet way and also send me the table description i mean table structure and which are indexed and all ok ! -----Original Message----- From: Vaishali S. Pandya [mailto:Vaishali_Shah@;RIL.COM] Sent: Sat 11/9/2002 2:51 PM To: [EMAIL PROTECTED] Cc: Subject: how to get data fast on the report HI Every body, I am doing MIS Reporting. I have to fetch 60000 rows at a time. In the Qry there is a join. All index are there. Right now the exewcution of the program takes 20 seconds I want to reduce it by 10 seconds. Thanks for the support, =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
**************************Disclaimer**************************************************
Information contained in this E-MAIL being proprietary to Wipro Limited is 'privileged' and 'confidential' and intended for use only by the individual or entity to which it is addressed. You are notified that any use, copying or dissemination of the information contained in the E-MAIL in any manner whatsoever is strictly prohibited. ****************************************************************************************