• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Performace Problem
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Performace Problem


  • Subject: Re: Performace Problem
  • From: Srinivas Adusumalli <email@hidden>
  • Date: Tue, 19 Dec 2006 11:24:55 +0530

HI ,

There are no relationships at all , all the columns are the class properties, i am using 5.2.4

Thanks & regards,
Sri

Ken Anderson wrote:

Hey Srinivas!

Are you firing any faults? I'm assuming you're timing just the fetch call, so probably not. What version of WebObjects is this with?

Lastly, if the columns are in your model as class properties, or they're not class properties but they're used in a relationship, they'll be fetched. Is your entity only a subset of the columns?

Ken

On Dec 18, 2006, at 10:48 AM, Srinivas Adusumalli wrote:

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:
40anderhome.com


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


References: 
 >Performace Problem (From: Srinivas Adusumalli <email@hidden>)
 >Re: Performace Problem (From: Ken Anderson <email@hidden>)

  • Prev by Date: Re: NSTimestamp problem
  • Next by Date: Re: NSTimestamp problem
  • Previous by thread: Re: Performace Problem
  • Next by thread: Re: Performace Problem
  • Index(es):
    • Date
    • Thread