100,000 plus quality content pages - How did they do it?

how do you make that many? surely not by hand right? what's the secret?

[PFOnline]

I was viewing a lyrics site, say lyricswidget.com for example...

And this site appears to have lyrics for just about every single song from every sing album by every single band/artist ever.

The way the site is structured is that the bands/artists are listed in A to Z order.

Once you select the band you want you can select the song you want the lyrics for and if you select say, "The Beatles" for example, this one band alone has well over 100 songs. Which means 100 content pages.

The reason I ask this is because I'm going to be making a similar site, (not a lyrics one, but just similar in structure) and haven't the slightest idea of how to make so many content pages by hand.

How did they do it?

[RobbieD]

IMO they are running some sort of software that builds static pages from their database. We run a similar program that generates over 100,000 static pages.

[PFOnline]

Hi Robbie, thanks for the response.

Would you mind maybe giving a little more info on how you did it?

Like what kind of database/software allows you to do this sort of thing.

I'm still completely in the dark and don't know where to start.

Is it using a MySQL type database?

[RobbieD]

Is it using a MySQL type database?

Yes.

There are lots of ways you can do it. The easiest would be use some search engine/dir software to build your database and in most cases they will allow you to build the pages static.

Send me a sticky and I will let you know of a great one to look into.

[moltar]

You can easily simulate having static pages, and they can be completely dynamic. Apache (mod_rewrite) + MySQL + Perl.

If you want, I can sticky you an example of my site, it looks static, but there are ~ 20,000 dynamic pages.