Re: Static pages vs CMS and the effect on SE's



"Timmermans" <steventimmermans@xxxxxxxxxxx> wrote:

> Hi everyone,
>
> My site is a little over 400 static pages in size and keeping the
> layout and menus up to date is starting to become a major pain in the
> bottom.
>
> I've been thinking about using a CMS to ease the burden somewhat. The
> question, should I keep using my static links or is it ok to switch
> and pull the content from a db?

If you do it right, Google can't see if it's dynamic or static.

The most important question though: how often are you going to update
the DB. If that's not that often a much better solution is to *generate*
your site locally, and upload all pages.

It's what I do (with over twice the amount of pages).

> I would like to retain my current positions within search engines if
> possible. The address created by the CMS has an id-tag in it... I
> read somewhere this is not something you would like to have.

Can't think up why. Check if your CMS has SEO friendly URLs. Some do
have mods/hacks to get it.

> Also, to
> my knowledge, using generated links does not allow me to use keywords
> in the url.

Not true. I generate, and I do have keywords in the URL.

> On the one hand I need to easy the worload on the other I wish to
> please the SE's.
>
> Pro's and contras are welcome.

The major con of a database if you really don't need it is that your
site hangs on two servers, the db server and the webserver. It increases
the risc of downtime. If your db isn't there, your site is gone.

In fact you have 3 options:

- generate each page on the fly from the database ("dynamic")

- check if the data in the page is more recent compared to the current
file. If you can't connect to the database: use the current file
If you can connect to the database, and the data is more recent,
serve this data, and update the file.

- generate your entire site locally using scripts, and upload the
results

If you go for the database approach, the 2nd option is the best [1],
*but* quite complicated.

I use the 3rd version: I have defined my own markup language using XML.
My site consists of several XML files (one file can include zero or more
other XML files). A perl script parses this file (twice, once to get all
the ids, the second time to generate the HTML pages).

A second program compares each file with a local copy of my site. If the
generated file is newer compared to the copy, the file is uploaded, and
the copy is updated (so I don't upload a thousand+ files each time).


The disadvantage is that it limits me somewhat. For example it's not
easy to integrate something like instantly publish comments posted by
people who registered with my site, and have a trusted status (future
project).


[1] unless your database changes extremely fast and most requests do
require a page update, and reporting the database down is more desired
compared to showing old data.

--
John Experienced (web) developer: http://castleamber.com/
Perl SEO tools: http://johnbokma.com/perl/
NEW ----> Textpad reference card (pdf): http://johnbokma.com/textpad/

.



Relevant Pages

  • Problem in Bulk Uploading of XML data?
    ... I want to import the data in bulk from XML Files to the Database. ... Rest of the nodes I want to show to the user so that he can correct them and upload to the database. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: I lose data, when I try to save a loaded DataTable on the click of another button in an asp.net
    ... that allows for the upload of an excel sheet into the database. ... I have an upload button and a save button. ... which is bound to a GridView for previewing before ... protected void Upload_Click(object sender, EventArgs e) ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Im about to commit matrimony (now with link)
    ... Keep tweaking the CV and upload new versions if the old ... with Wboserve yesterday, but their upload pages were borked. ... database and run several different filters against it. ... There's still an awful lot of COBOL code around and universities don't teach ...
    (uk.rec.sheds)
  • Re: form to email document
    ... >> append the Session ID for that user Session to the file name. ... >> name uploaded.This can come from a simple text file or a database. ... >>> I was hoping for something like the procedure used to upload a form, ...
    (microsoft.public.frontpage.programming)
  • Re: Can you Upload a file and update a db on 1 form?
    ... You will need to create a form, then submit it to the database, then in the next step in the process ... allow the user to upload a file and then update the record that was created in the first step, ... security update, then there is usually no charge for the call. ... > user to upload a newsletter and update the database with the same form. ...
    (microsoft.public.frontpage.programming)