Skip to main content
R
rviner
Participant
March 30, 2011
Question

Problems with indexing large data using verity

  • March 30, 2011
  • 1 reply
  • 289 views

Hi,

I am currently running coldfusion 8 with verity running on a K2 server. I am using a query to index several different columns with my table using cfindex. One of the columns is a large varchar type.

It seems that when the data is being indexed only the first 30KB is being stored, resulting in no results being brought back if I search for anything after that. I tried moving several different phrases and words further up in the data,  within the 30KB and the results then appear.

Does anyone know if there is a limit to the amount of data being indexed and if there is a way to change this in the configuration?

Many thanks,

Richard

    This topic has been closed for replies.

    1 reply

    R
    rvinerAuthor
    Participant
    March 31, 2011

    I have been running a few more tests and using the browse command in the command prompt to see whats actually in the collection.

    i.e. Coldfusion8\verity\collections\<collectionname>\parts  browse 0000001.ddd

    I found out that the body being indexed (CF_BODY) never exceeds the size of 32000.

    Can anyone tell me if there is a fixed index size limit for verity or if it may be a coldfusion memory setting or database setting?

    I'm using SQL server 2005 to run my query to update the collection.

    Many Thanks,

    Richard

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices