Anyone know why this code would run slower and slower (lines per second) .
are there any limitations to dataset or adding new rows? any way to
optimize?

add field id to objDataTableFieldIdTrans

vtest = vtest & vFieldId

objDataRowTrans = objDataTableFieldIdTrans.NewRow()

objDataRowTrans("fieldid") = vFieldId

objDataTableFieldIdTrans.Rows.Add(objDataRowTrans)

objDataTableTrans.Rows.Add(objDataRowTrans)

How to measure that the code is running slower and slower?

Let me know how you test the code to get a slower performance.

--
Peter Wu
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure?  For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.