User-agent: Mozilla Thunderbird 1.0.6 (Windows/20050716)
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:
http://lists.apple.com/mailman/options/webobjects-dev/email@hidden
