[consulting] Question about using Drupal for large searchable database

Al Sessions fultonchain at gmail.com
Sat May 5 00:37:54 UTC 2012


I just did something similar at <http://valecemetery.org>.

Importing from the database with Feeds and using exposed filters in
Views seemed to do the trick.

It's not a high volume site and I'm not overly concerned with performance.

On Tue, May 1, 2012 at 9:25 AM, Sam Cohen <sam at samcohen.com> wrote:
> This list has sure gone quiet lately.  Is everyone just so busy with work?
>
> (Sorry if this isn't the place to ask this.  If anyone knows a better place,
> please advise. )
>
> 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.
>
> 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.
>
> It's a D6 site for a relatively small nonprofit without a lot of traffic.
>
> How would you handle it?  Custom module or content type/Views?
>
> Thanks,
> Sam


-- 
Al Sessions


More information about the consulting mailing list