Hi, I have to show 100's of article on my website, is it good to develope just one page and pick articles from database and display or i should maintain all 100's static html by keeping SEO in the mind?
for SEO, make it as static page for easy manage, use database what I will do is, use database, create static pages.
I would go for dynamic, too. But if you also ask if you shall have just one page with all articles on it, or 100 different pages, 100 different pages are much better solution.
It is insane to create 100 static pages because SEs will treat dynamic as different pages anyway. Make sure your page title is created dynamically, and that you populate meta tags dynamically and be sure they are specific to the article. In fact, I would have a dynamic 'category' page which lists related articles. This is a 'tree' structure. The article database should have a category field for each article. Then on your category page you use something like .some-domain.com?ctgry=apples which lists all articles for apples. Then .some-domain.com?ctgry=bananas which lists all articles for bananas... see?
Or better yet, use mod rewrite so it is some-domain.com/bananas and the articles themselves are in the format some-domain.com/bananas/banana-nutrition, so you get keywords in the url.
Hi, Generally speaking, there would be no big difference between dynamic and static pages these days for SEO purpose. In my own experiences, it would be better to page your 100 article in several pages and then link between them. all the best,
Static pages are better than dynamic. But if you use dynamic content through database, then make sure you are using url rewriting for your posts/articles. Because dynamic urls are not easy to index by Google.