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 protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
