I have a dynamic website in which products, news and other stuff are added on daily basis. Since, I read everywhere having a sitemap can only help but not hurt the site, I decided to create one for myself using an online sitemap generator website and uploaded it to the root of my website. Currently i have 5000 URLS which should increase over time i guess.
My question is can I follow the procedure of weekly generating and updating the sitemap file at server for search engines or should i do it daily?
What's your opinion in this regard, a static generated sitemap for a dynamic website? Also having a sitemap won't stop google bots from crawling the website daily?
Let me know your opinions as to whether to go forward with this or drop the sitemap altogether