Xml file are must for sitemap ?

Question

0.00/5 (No votes)

See more:

hello all good afternoon

i have some dynamic and satic data for sitemap .and my dynamic data coming from sql server dataabse .xml file are must for sitemap for seo ?is it good to bind sitemap data from sql? or we will have to bind from xml file.? please tell me ,i am littl bit confused .

What I have tried:

i am binding sitemap with sql database

Posted 17-Mar-16 21:37pm

manvendra patel

Updated 18-Mar-16 3:02am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

v2

Add a Solution

Comments

[no name] 18-Mar-16 5:17am

It is always better to use look up. SO choose xml file instead of Database.

Firstly you can easily modify in xml file as compared Database.
Secondly connecting to DB every time and closing the connection is bad as compared to xml.

manvendra patel 18-Mar-16 5:52am

but my sitemap are dynamic. i am working on eCommerce website .there is lot of dynamic category subcategory in my database .i want to show this category on sitemap page.then how can we use xml file instead of database.?

F-ES Sitecore 18-Mar-16 6:26am

"sitemap" has no official definition, it means different things to different people so you'll need to explain what you mean by "sitemap"

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Answer 1 · 2016-03-18T03:02:00

I've had no problems using a dynamicly-generated sitemap with a generic handler (.ashx). So long as the handler generates the correct XML, and you add a link to it in your robots.txt file, it should be fine.

Sitemap: https://www.your-site.com/sitemap.ashx

You can also submit your sitemap file via the Webmaster Tools sites for Google[^] and Bing[^].