Database selection, SEO

ishan

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: [email protected]

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

BangaruBabu Pureti16y ago
Accepted 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 Hobbs16y ago
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.
ishan16y ago
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 Hobbs16y ago
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.