RE: Performace Problem
RE: Performace Problem
- Subject: RE: Performace Problem
- From: "Marcin Lukasiak" <email@hidden>
- Date: Mon, 18 Dec 2006 17:04:30 +0100
Hi,
I think that you are using this data for some calculation because I
don't belive that you whant to display them. In such situation when there
are many rows to fetch you will always have performance issues (maybe not so
big). Try to move your calculation to DB side (stored procedure or view if
feasible) where they can be significantely faster. If you need those data
for showing them then think about it once again.
Regards,
> -----Original Message-----
> From:
> webobjects-dev-bounces+marcin=email@hidden.c
> om
> [mailto:webobjects-dev-bounces+marcin=blackstudio.civ.pl@lists
> .apple.com] On Behalf Of Srinivas Adusumalli
> Sent: Monday, December 18, 2006 4:49 PM
> To: email@hidden
> Subject: Performace Problem
>
> 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:
0blackstudio.civ.pl
>
> 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