Results 1 to 4 of 4

Thread: [MSSQL] blob-upload in table with full text index goes slow

  1. 10-31-2005, 09:52 AM #1
    haroldd
    haroldd is offline Registered User
    Join Date
    Oct 2005
    Posts
    2

    Question [MSSQL] blob-upload in table with full text index goes slow

    i have a MSSQL 2000 database with about 30 tables in it. On one of those tables i've defined an full text index on an image field. In this table are around 500 records with binary files.

    it functioned well for a time but now when i try to upload a file into the table this goes extremely slow (300 KB takes over 3 minutes).

    i tried disabling "change tracking" but this didn't help a thing

    adding blobs to other tables (without fulltext index on it) still goes fast.

    what could be a reason that the uploading goes so slow??
    Reply With Quote Reply With Quote
  2. 10-31-2005, 11:01 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Possible to remove full text index then try again?
    Reply With Quote Reply With Quote
  3. 11-01-2005, 02:50 AM #3
    haroldd
    haroldd is offline Registered User
    Join Date
    Oct 2005
    Posts
    2
    Quote Originally Posted by rmiao
    Possible to remove full text index then try again?
    i tried this tonight but this didn't help either.
    Reply With Quote Reply With Quote
  4. 11-01-2005, 10:31 AM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    How did you load it? Did you put image data in separate filegroup?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules