<HTML><HEAD></HEAD>
<BODY dir=ltr>
<DIV dir=ltr>
<DIV style="FONT-FAMILY: 'Calibri'; COLOR: #000000; FONT-SIZE: 12pt">
<DIV>Sam -</DIV>
<DIV> </DIV>
<DIV>I would suggest you to use apachesolr and views combination to handle
search for such a large set of dataset.</DIV>
<DIV> </DIV>
<DIV>Regards,</DIV>
<DIV> </DIV>
<DIV style="FONT-FAMILY: 'Calibri'; COLOR: #000000; FONT-SIZE: 12pt"><SPAN
style="FONT-FAMILY: georgia; COLOR: #000000; FONT-SIZE: 14pt">Awtar Singh</SPAN>
<BR><SPAN
style="FONT-FAMILY: georgia; COLOR: #000000; FONT-SIZE: 10.5pt">Executive
Director </SPAN></DIV>
<DIV style="FONT-FAMILY: 'Calibri'; COLOR: #000000; FONT-SIZE: 12pt"><SPAN
style="FONT-FAMILY: georgia; COLOR: #000000; FONT-SIZE: 10.5pt"></SPAN> </DIV>
<DIV style="FONT-FAMILY: 'Calibri'; COLOR: #000000; FONT-SIZE: 12pt"><SPAN
style="FONT-FAMILY: georgia; COLOR: #000000; FONT-SIZE: 10.5pt"></SPAN><SPAN
style="FONT-FAMILY: georgia; COLOR: #000000; FONT-SIZE: 11pt">e:
asingh@quantum-coders.com</SPAN><BR><SPAN
style="FONT-FAMILY: georgia; COLOR: #000000; FONT-SIZE: 11pt">w:
www.quantum-coders.com</SPAN></DIV>
<DIV
style="FONT-STYLE: normal; DISPLAY: inline; FONT-FAMILY: 'Calibri'; COLOR: #000000; FONT-SIZE: small; FONT-WEIGHT: normal; TEXT-DECORATION: none">
<DIV style="FONT: 10pt tahoma">
<DIV><FONT size=3 face=Calibri></FONT> </DIV>
<DIV style="BACKGROUND: #f5f5f5">
<DIV style="font-color: black"><B>From:</B> <A title=sam@samcohen.com
href="mailto:sam@samcohen.com">Sam Cohen</A> </DIV>
<DIV><B>Sent:</B> Tuesday, May 01, 2012 6:55 PM</DIV>
<DIV><B>To:</B> <A title=consulting@drupal.org
href="mailto:consulting@drupal.org">A list for Drupal consultants and Drupal
service/hosting providers</A> </DIV>
<DIV><B>Subject:</B> [consulting] Question about using Drupal for large
searchabledatabase</DIV></DIV></DIV>
<DIV> </DIV></DIV>
<DIV
style="FONT-STYLE: normal; DISPLAY: inline; FONT-FAMILY: 'Calibri'; COLOR: #000000; FONT-SIZE: small; FONT-WEIGHT: normal; TEXT-DECORATION: none">This
list has sure gone quiet lately. Is everyone just so busy with
work?<BR><BR>(Sorry if this isn't the place to ask this. If anyone knows a
better place, please advise. )<BR><BR>A client of mine with a Drupal site I
inherited wants to bring in a very large database into their site. It's
basically over 200,000 genealogical/cemetery records that need to be searchable
by users. I'm struggling over whether to do it (1) as a custom
module, with it's own separate database or (2) to do it with views/content type
and node import. The client also needs to be able to edit the records
through the site. <BR><BR>The latter approach would be quicker to set up,
but I worry that it would bloat the site, potentially cause performance issues,
and perhaps other problems I'm not thinking about. <BR><BR>It's a D6
site for a relatively small nonprofit without a lot of traffic.<BR><BR>How would
you handle it? Custom module or content
type/Views?<BR><BR>Thanks,<BR>Sam<BR><BR clear=all>Sam Cohen, Principal<BR><A
href="http://new-media-solutions.com" target=_blank>New Media
Solutions</A><BR>Drupal Training & Services<BR><I><A
href="http://new-media-solutions.com/drupal-training" target=_blank>New Courses
Starting Soon</A></I><BR><BR>
<DIV style="DISPLAY: inline"></DIV>
<DIV style="DISPLAY: inline"></DIV><BR>
<P>
<HR>
_______________________________________________<BR>consulting mailing
list<BR>consulting@drupal.org<BR>http://lists.drupal.org/mailman/listinfo/consulting<BR></DIV></DIV></DIV></BODY></HTML>