homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

sql profiler cpu over 400 - can you help with the query?

10+ Year Member

Msg#: 3659879 posted 2:05 pm on May 27, 2008 (gmt 0)

I have the following query which uses mssql 2000 full text search but still shows up as a massive 400+ on the sql profiler and over 20,000 reads. The db table is large (300,000+ posts) but I thought the point of the full text service was to make this sort of search doable. Can anyone suggest a way to do this kind of full text search without such high CPU usage (whatever 400 means anyway? 400%?!)

select top 30 a.forumid, a.guestname,a.email,a.topicid,a.id,a.subject,a.replycount,a.lastreplydate, a.hits, c.Forumname ,a.message from post a, forum c where c.categoryid in (0,1,5,11) and a.topicid=0 and (CONTAINS(message, ' "blah blah keywords" ') or CONTAINS(subject, ' "blah blah keywords" ')) and a.forumid=c.id order by lastreplydate


Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved