Database selection, SEO

Question

I am developing a website in ASP.net 3.5 where there is a very big database. I have to show data on one single page dynamically changing from the database and that database will contain data of about 4000 pages having text and images. With formatting tags and lot of tags, its size become huge, So please suggest which database i should use, MS SQL or XML, I don't have any problem ob database size and web space. i have to choose the fastest one,
Due to such a big database, XML data file will also becomes very big, i can't categorize it into separate files, I will use linq for data reterival , Please tell me if big size of XML can make any problem in speed comparing to sql.

I have one more problem regarding SEO(search engine optimization), Can google search the data in any one of databases if i will provide the the links, For better SEO, suggest me also, U can also reply me on my mail: ishan.chawla87@gmail.com

BangaruBabu Pureti · Answer

Hi Ishan! if U want to search ur data there is a pretty much good feature in SqlServer 2005 called Full Text Based Search(Like Google Search).For That Here I am attaching One Zip File How U can Make Ur Database Search Fast. Sql Server is the Best Way To Meet Ur Task Very Simple. And One More if u Want Improve SEO ..You Need To Add Meta data Keys More To Ur Database. I attached One Zip File for full Text based Search With Huge volume of Database

Sam Hobbs · Answer

Ooooh, that SEO stuff I don't know. I am sorry. I hope someone else can help. SEO and search engines are things I have not needed to be concerned about. I know many people do need to be. After thinking about it, I realize that if an XML file is available among otehr files in a server, then a search engine would probably search the XML. I am not sure how that works. I don't know if a search engine searches a SQL Server database. I suppose you could export the data to XML from a SQL Server database but I think it is better to determine for sure whether that is necessary.

ishan · Answer

Thanks Sam, tell me if i will dynamically generate title, keywords and meta tags on form load, will google search those tags through links regarding SEO

Sam Hobbs · Answer

Without more information, I would say that SQL Server is definitley better than XML. XML will definitely be slow if the data is too big to fit in main memory all at once. If there is a reason that SQL Server can't be used then it might be possible to make XML reasonably efficient but otherwise SQL Server is the best use of your time and the computer's time.

Database selection, SEO

passaG GUIDE