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.
****************************************************************************************