Re: Performace Problem
Re: Performace Problem
- Subject: Re: Performace Problem
- From: Steve Quirk <email@hidden>
- Date: Mon, 18 Dec 2006 12:24:13 -0500 (EST)
On Mon, 18 Dec 2006, Srinivas Adusumalli wrote:
Hi Everyone,
I have a performance problem while fetching records from the database.
30,000 times 70 columns? Of course you are.
Is this for a report? (Even at 100 lines/page would be a 150 page report
double sided, so I doubt it). You should try to have the database do
whatever aggregate function you need on the rows & return that.
If you absolutely must have the rows, you should consider using just the
jdbc api. EOF really isn't well suited for this kind of fetch.
- sq
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
_______________________________________________
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