RIL_button( “http://sqlconcept.com/2012/12/30/sql-server-2012-full-text-search-and-xml-search-the-wiki-project/”, “SQL Server 2012 Full-Text search and XML Search – the Wiki project” );
Finally, here are some results from the Wiki project.
After a few days of development, here is the accounting for the wiki project:
Desktop PC with 8Gb RAM, single home use HDD
SQL Server 2012, using XML and Full-Text search
the total amount of data
Continue reading [...] SQL Server 2012 Full-Text search and XML Search – the Wiki project [...]
RIL_button( “http://sqlconcept.com/2012/12/29/full-text-catalog-properties-sql-server/”, “Full-Text catalog properties – SQL Server” );
Recently I have been working with the Wiki project – just to prove that my desktop PC can be as fast as Windows Azure in hosting and searching through the entire Wiki content.
In order to do that I created a local database which contains all wikipedia articles
Continue reading [...] Full-Text catalog properties – SQL Server [...]
RIL_button( “http://sqlconcept.com/2012/12/27/azure-vs-inhouse-sql-server-the-wiki-project-performance-tuning/”, “Azure vs. inhouse SQL Server – the Wiki project – performance tuning” );
In my earlier blog post I wrote about setting up the WikiDB database and importing the files.
Initially I was inclined to import the XML files as they came – the files had different sizes ranging from 140 Mb to 7 Gb.
Continue reading [...] Azure vs. inhouse SQL Server – the Wiki project – performance tuning [...]