Collection split - @DbColumn

HCL Domino Domino Forum
1

Hi All,

I have done view.FTSearch which returned some collection of documents. Now I need to pickup a field value from each of the documents and put it in a text field.

But as @DBColumn has a limitation of 64k and text field has limitation of 32k, its being difficult of updating the field value into a single field.

So, I thought of splitting the collection into parts (say 1500 documents) and put the values into a individual text field.

How to split the collection of documents into 1500 sets so that processing of my code will be faster.

The code right now is working fine and is looping through the searched collection of documents. The problem is that if the search results are more i.e 10,000 or more then the agent is taking lot of time to process the same.

Could someone help me in solving this. I want to split the documents in a view into 1500 set(s).

–Phani

2

Subject: 64K @dbcolumn

If document collection count more, 64k error will come. To overcome this limitation use code as follows:

IntCount=coll.count/1550

If Fraction(IntCount) > 0 Then

	IntCount=Fix(IntCount) +1		

End If



Dim LeastCounter As Integer

LeastCounter = coll.count

tempcount = 1550



If counter < 1 Then counter = 1

tempcounter = 1

copynum = 1

For i=1 To IntCount			

	If i=1 Then

		Bac1=Evaluate({@subset(@DbColumn("";"":"";"(Sort BACs)";1);} + tempcount + {)})

	Else

		If LeastCounter >= 1550 Then

			Bac1=Evaluate({@subset(@subset(@DbColumn("";"":"";"(Sort BACs)";1);} + tempcount * i + {); -1550)})	

		Else

			Bac1=Evaluate({@subset(@subset(@DbColumn("";"":"";"(Sort BACs)";1);} + tempcount * i + {); -} + Cstr(LeastCounter) + {)})	

		End If

		

	End If

	If LeastCounter > 1550 Then

		LeastCounter = LeastCounter - 1550

	End If

.

.

.

.

.

Next