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

Question

Question

Update Page Data Stored Procedure

asked on February 26, 2016

Hi,

We have a client who are reporting that a particular stored procedure ("update_page_data") is causing high CPU load. It appears to run during the night.

Is this stored procedure configured to run at times of low system load only and is the schedule configurable in any way?


Thanks,
 

Nigel.

0 0

Replies

replied on February 26, 2016

This stored procedure only runs when there is something that's trying to modify a document page. It is probably being run as part of page thumbnail generation. Please check the rows of the dboptions table to see if there's a row where optionname = 'BackgroundThumbnailGenerator'. If so, you can disable thumbnail generation by setting the optionvalue column to '0' for that row and restarting LFS.

There is a way to schedule when this runs but it's a bit complex to explain, so first please verify if that row is present in the dboptions table and if your client is willing to simply disable it. If that row is not present then further investigation will be required.

1 0
replied on March 15, 2016

Hi Michael - that row isn't present in the dboptions table so it must be something else triggering it. It is reported to be causing significant performance issues throughout the day now - typically what other triggers for this would there be?
 

0 0
replied on March 16, 2016

Laserfiche?

0 0
replied on March 16, 2016

The BackgroundThumbnailGenerator row isn't in dboptions by default, you need to add it to disable the background thumbnail generation.

0 0
replied on March 16, 2016

Thanks Robert,

 

What impact will this have? Will this mean that the documents won't have any thumbnails?

 

Cheers!

0 0
replied on March 16, 2016

No, it means thumbnails will be generated on-demand (when someone first opens the document) instead of as a background task.

1 0
replied on March 16, 2016

Thanks for clarifying Robert. yes

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.