One Site One Page?

is pulling everything from a database a dumb idea?

[old_expat]

For the past couple of days I have been fiddling with a few sites .. altogether about 2,000 pages. I'm on a slow connection and uploads can get pretty boring.

I've been intrigued with the idea of building what should probably be a multi-page static site .. as a one-page site (+CSS) .. even much of the HTML code.

Is that a dumb idea? I really don't have much of an idea at what speed database queries are served compared to how static pages with some database queries are served.

Actually, I don't even know many of the right questions to ask.

I assume that one of the issues would be updating the database rather than adding pages.

I'm getting ready to build a site that will uses several database queries, so I was thinking ..

Please forgive my ignorance.

Recommendations?

[mattur]

Yes it's easily do-able and speed shouldn't be a problem, but ideally you would probably want to implement an information architecture of "theme pyramids" with friendly urls too, which is a bit more challenging. Having all your urls look like www.example.com/displaypage?id=1 is a bit 20th century ;)

You may want to consider using off-the-shelf publishing (free) software instead, like WordPress, Drupal, Joomla etc.