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.

****************************************************************************************

Reply via email to