I want to build report from 40-50 database,but i found what is too slow, how to improved performance?
Subject: RE: About FTsearch or DBSearch in multi-DB?
I want to go from my house to somewhere, but I find the way I’m going is too slow. How can I get there faster?
To answer the question, you would need to know where I’m going and (preferably) how I’m traveling now.
A multi-database full-text search is faster than 50 individual full-text searches, but you can’t search by specific fields in that case, and the results are not organized in any useful order.
50 individual full-text searches are far faster than using db.Search 50 times, provided the databases are full-text indexed. I believe you should be able to get the results in view order, if you have a view whose ordering is to your liking.
If you had a special view in each database that contained the documents that you need for your report, in a useful order, that would be maybe a bit faster than a 50 full-text searches, especially if you used the view index to get the field values instead of reading them from the document.