We have been working on a POC that involves a reasonably complex BDC mapping on the AdventureWorks2005 database. We are including about 10 entities with numerous associations.
The BDC generation was reasonable straight forward (one problem we had I will post about seperately) however I am finding the indexing of the content to be painfully slow. This is running on a single machine (so results will not be indicative of live) but we have found that it has taken over 4 hours to index 150,000 entities (works orders, products etc).
Also the SharedServices_Search database has grow to over 2GB which is a significant multiplier on the base data of about 170MB, do we have any numbers of this or is it totally dependent on the mappings, associations and if the crawed content is included in the index
Has anyone else found this problem Is this a BDC V1 issues or are we trying to do things with the BDC that it was not really built for
I have not done any SQL profiling (will if we get time).
Any help/pointers on performance improvements greatly recieved.
SharePoint Products and Technologies2