Performace Problem
Performace Problem
- Subject: Performace Problem
- From: Srinivas Adusumalli <email@hidden>
- Date: Mon, 18 Dec 2006 21:18:54 +0530
Hi Everyone,
I have a performance problem while fetching records from the database.
I just have 30000 records in a table and when i fetch those records
using fetch specification its taking nearly 25 seconds, i am fetching
the records based on a qualifier using 3 of the columns, i tried
creating indexes on those columns and when i run the SQL query saying
select * from tablename where clause the Execution plan shows a very
little Elapsed time but when i fetch those records from the Application
its nearly taking 25 seconds , i also tried fetching using the rawRows
concept but it also didn't help , this also takes almost the same time
if i include most of the columns present in the table, there are nearly
70 columns in the table. Is there a way to improve the performance
Thanks & Regards,
--Sri
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden