You are viewing limited content. For full access, please sign in.

Discussion

Discussion

Is it OK to add an index to the value column in the cf_bp_data table in Forms?

posted on March 11, 2016 Show version history

We have a Forms/Workflow process where Workflow does a lookup on the value column of cf_bp_date column after the form is submitted. Because there's a lot of submissions and the column isn't indexed, sometimes this lookup takes a while (30+ seconds), especially if the database is under heavy load.

We were thinking about adding an index to this column, but wanted to ask Laserfiche first to see if it's OK to do so.

1 0
You are not allowed to reply in this post.

Discussion 1

Sign in to reply to this post.