Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2009
    Posts
    16

    Question Unanswered: Fulltext searching very slow

    Hi,
    I have transactional table (tblDocument). I've create a full text catalog on column [docSubject] in a separated partition.(with manual tracking and it's not sensitive).I've increase my server virtual memory for fdhost. My search should be like this :

    SELECT docId,DocSubject,docDate
    FROM tblDocument WITH (NOLOCK)
    WHERE docDate BETWEEN 13880101 AND 13880901 AND CONTAINS(docSubject , '"آقای صادقی*"')


    (combination my criteria and "contains" like that )
    this query takes about 1 min to execute !!!!
    I'm wonder that when I dont use my criteria query executes in 0 sec !!!
    and the same will occurs when I use my criteria only !!!

    use full text search only :

    SELECT docId,DocSubject,docDate
    FROM tblDocument WITH (NOLOCK)
    WHERE CONTAINS(docSubject , '"آقای صادقی*"')


    use my criteria only :

    SELECT docId,DocSubject,docDate
    FROM tblDocument WITH (NOLOCK)
    WHERE docDate BETWEEN 13880101 AND 13880901

    what should I do now ???!!!

  2. #2
    Join Date
    Sep 2009
    Posts
    16
    anyone cant help me!!!
    my boss will kill me

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    How does this fair?
    Code:
    SELECT docId,DocSubject,docDate
    FROM   (
            SELECT docId,DocSubject,docDate
            FROM tblDocument WITH (NOLOCK)
            WHERE CONTAINS(docSubject , '"آقای صادقی*"')
           ) As a_subquery
    WHERE  docDate BETWEEN 13880101 AND 13880901
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •