Solr is another option, as well as xapian. All are external search engines, all are fast. All require integration too.<br><br>In this case, Sphinx has an advantage: it hooks into MySQL tables natively. <br><br>Which makes it worth checking first for this project.<br>
<br><div class="gmail_quote">On Wed, Mar 25, 2009 at 11:36 AM, David Hazel <span dir="ltr"><<a href="mailto:dave@hazelconsulting.com">dave@hazelconsulting.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
I was going to say try /solr or /apachesolr<br><br>DrupalCon DC Session<br><a href="http://dc2009.drupalcon.org/session/more-search-how-apachesolr-changes-way-you-build-sites" target="_blank">http://dc2009.drupalcon.org/session/more-search-how-apachesolr-changes-way-you-build-sites</a><br>
<br>Also I think the video of the session is up here:<br><a href="http://aaronwinborn.com/video/more-search-how-apachesolr-changes-way-you-build-sites" target="_blank">http://aaronwinborn.com/video/more-search-how-apachesolr-changes-way-you-build-sites</a><br>
<br>-dave<br><br><div class="gmail_quote">2009/3/25 Khalid Baheyeldin <span dir="ltr"><<a href="mailto:kb@2bits.com" target="_blank">kb@2bits.com</a>></span><div><div></div><div class="h5"><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Looks like a job for Sphinx.<br><br>Check out these as the basis for your project:<br><br><a href="http://drupal.org/project/sphinxsearch" target="_blank">http://drupal.org/project/sphinxsearch</a><br><a href="http://drupal.org/project/sphinx" target="_blank">http://drupal.org/project/sphinx</a><br>
<br><div class="gmail_quote">2009/3/25 William Schaepe <span dir="ltr"><<a href="mailto:wschaepe@earthlink.net" target="_blank">wschaepe@earthlink.net</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div><div></div><div>
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p>I need a Drupal consultant to write a custom Search module:</p>
<p> </p>
<p>My client has a Drupal installation running multiple sites
(four) on the same server. In each site there are non-drupal MySQL tables
that contain thousands of HTML pages. Currently there are three such tables,
but more will be added in the future.</p>
<p> </p>
<p>The search module needs to search through the non-Drupal tables
for keywords and keyword phrases and generate a page(s) of prioritized
results. The viewer needs to be able to click on a result and view the
HTML page within the Drupal page.</p>
<p> </p>
<p>Many (most) of the HTML pages have hyperlinks to other
pages. These links were generated when all the files were in folders and have
relative addressing. Now the page they will be pointing to will be some
record in the table.</p>
<p> </p>
<p>Regards,</p>
<p>Bill Schaepe</p>
<p> </p>
<p>William Schaepe</p>
<p>Lenox Web</p>
<p>646-213-6427 (Office)</p>
<p>718-766-7480 (Fax)</p>
<p>wschaepe@LenoxWeb.net</p>
<p><a href="http://www.LenoxWeb.net" target="_blank">www.LenoxWeb.net</a></p>
<p> </p>
</div>
</div>
<br></div></div>_______________________________________________<br>
consulting mailing list<br>
<a href="mailto:consulting@drupal.org" target="_blank">consulting@drupal.org</a><br>
<a href="http://lists.drupal.org/mailman/listinfo/consulting" target="_blank">http://lists.drupal.org/mailman/listinfo/consulting</a><br>
<br></blockquote></div><font color="#888888"><br><br clear="all"><br>-- <br>Khalid M. Baheyeldin<br><a href="http://2bits.com" target="_blank">2bits.com</a>, Inc.<br><a href="http://2bits.com" target="_blank">http://2bits.com</a><br>
Drupal optimization, development, customization and consulting.<br>
Simplicity is prerequisite for reliability. -- Edsger W.Dijkstra<br>Simplicity is the ultimate sophistication. -- Leonardo da Vinci<br>
</font><br>_______________________________________________<br>
consulting mailing list<br>
<a href="mailto:consulting@drupal.org" target="_blank">consulting@drupal.org</a><br>
<a href="http://lists.drupal.org/mailman/listinfo/consulting" target="_blank">http://lists.drupal.org/mailman/listinfo/consulting</a><br>
<br></blockquote></div></div></div><br><br clear="all"><br>-- <br>Email is not a secure form of communication!<br><br>Technologist<br><a href="http://www.hazelconsulting.com/" target="_blank">http://www.hazelconsulting.com/</a><br>
253.686.0296<br><a href="mailto:dave@hazelconsulting.com" target="_blank">dave@hazelconsulting.com</a><br>
skype: hazelconsulting<br>gtalk:kananii<br>ICQ: 366587185<br>
</blockquote></div><br><br clear="all"><br>-- <br>Khalid M. Baheyeldin<br><a href="http://2bits.com">2bits.com</a>, Inc.<br><a href="http://2bits.com">http://2bits.com</a><br>Drupal optimization, development, customization and consulting.<br>
Simplicity is prerequisite for reliability. -- Edsger W.Dijkstra<br>Simplicity is the ultimate sophistication. -- Leonardo da Vinci<br>