How robust the SQL Server 2005 is..?
-
Hi All, I am planing to use SQL server fulltext search and xml to store data of a ecommerce site (mainly its products).. the site is having about 20 million products.. I am going to store all the product in xml type.. and I need to search them extensively.... The site going to have lots of users .. I am assuming about 500000 page views per hour.. but all these will not hit the search button .. (we use cache to reduce the database hits as much as possible) In a scenario like this .. is it a good approach to use xml ? Is the SQL fulltext search can perform well here, in simple term is the SQL server the choice here?? Please give me your honest :) answers I need to make a choice here.. Also if you suggest me to go with SQL please attempt to assist me with some links where I can find tips to improve the SQL server performances to hold on to this heavy load..
L.W.C. Nirosh. Colombo, Sri Lanka.