I have a Oracle DB table with 3 columns and 500,000 rows. I have successfully created an ADF, uploaded it to SharePoint, and it works. My BDC defines a method for Finder:
Select "SSN","FIRST_NAME","LAST_NAME" From myTable where("LAST_NAME" LIKE :LastName) and ("FIRST_NAME" LIKE :FirstName) and ("SSN" LIKE :SSN)
Select "SSN","FIRST_NAME","LAST_NAME" From myTable Where ("SSN"=:SSN)
The queries work, but the SpecificFinder (even when placed on its own page, referenced through a Business Data Item Web Part) takes upwards of 40 seconds to load, while the the Finder returns data in anywhere from 5-7 seconds (for instance, when filtering
on SSN or even when returning a large set of data filtering on Last Name). This is totally counter-intuitive and we cannot seem to figure out why the SpecificFinder is taking so long.
When watching the database during the execution of a SpecificFinder, we see that the session remains open for the entire 40 seconds, so SharePoint and Oracle are conversing during this period. As soon as the session ends, the data is immediately presenting
in the web part. We know it only takes a fraction of a second to run the SpecificFinder query, so someth
View Complete Post