Unless you have a large install the best way to do a network wide search is Sitewide Tags http://wordpress.org/plugins/wordpress-mu-sitewide-tags/.
Set the blog name to be search (or similar),
Set the privacy setting to discourage search engines,
Set SWT to include non-public sites.
Then for global search send your visitors to the search blog you’ve set up. It will search the local content but the permalinks on the tags blog link back to the original site.
Ron, thanks for getting back. And, what would you suggest if the install is a large one?
Ron,
I am going to write a parallel query to each of the databases. Creating one database with all posts such as Sitewide Tags seems to defeat the purpose of Shardb. I’ll let you know how it goes when finished.
DolphinGuy
Ron,
Seems I have run into another limitation. The limitation of only being able to search 61 tables with 1 query. Any suggestions on how to search across multiple database with multiple tables? And do it fast?
DolphinGuy
what would you suggest if the install is a large one?
If it’s a large one then look at implementing something like Sphinx.
Creating one database with all posts such as Sitewide Tags seems to defeat the purpose of Shardb.
Sitewade tags creates a site vs a database.
Any suggestions on how to search across multiple database with multiple tables? And do it fast?
There is no way to do that (even with just the 16 DB config). That’s why I suggested Sitewide Tags. It aggregates all the content you want searched into a single site.
