My Cart
Log In
Register
an ASP.NET Open Source CMS & eCommerce platform
Search:
Home
Open Source Edition
DotShoppingCart Suite
Services
Support
Blog
Marketplace
Buy
Forums
Video Tutorials
Documentation
Premium Support
Submit Support Ticket
Home
>
DotShoppingCart Forums
>
Support
>
Using DotShoppingCart
>
Sql Server 2008 Full-Text Search
Sql Server 2008 Full-Text Search
Last Post 5/1/2009 7:55:55 AM By lukezy. 3 replies.
4/9/2009 11:51:01 AM
gersh
Posts: 5
Joined: 11/19/2008
Sql Server 2008 Full-Text Search
Hi,
Full-text search worked great on Sql Server 2005. However, Microsoft seems to have messed it up in Sql Server 2008. It seems to work, but it is often unbearably slow with DSC. Is there any fix or workaround for this?
4/9/2009 12:04:02 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
website
Re: Sql Server 2008 Full-Text Search
Your observation is absolutely right. The new Full-text search in SQL server 2008 is having problems generating the good query plans. The major issue was full-text search involved with the multiple tables joins. We found the workaround is to use UNIONs rather than JOINs. The new version DotShoppingCart V3.1 has the workaround in place. You can either migrate to V3.1 or just fix the several search sprocs (check MigrateV3.0ToV3.1.sql).
DotShoppingCart Staff
5/1/2009 4:42:53 AM
gersh
Posts: 5
Joined: 11/19/2008
Re: Sql Server 2008 Full-Text Search
Where do I get the migrate SQL file?
5/1/2009 7:55:55 AM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
website
Re: Sql Server 2008 Full-Text Search
Go to the order detail page and download the V3.1 DoShoppingCart Suite. After you unzip the package, you should find the migration script in the migration subfolder. Find the search sprocs and apply those to your SQL server.
DotShoppingCart Staff