On 18.12.2006, at 16:48, Srinivas Adusumalli wrote:
I have a performance problem while fetching records from the database.
What 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
Sure - but you haven't provided enough information. 1. What database? (Vendor and version) 2. How many rows in the result set? 3. Relationships that have to be resolved? Have you tried logging the SQL and using exactly this SQL directly? cug _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
