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

Question

Question

Recurring query

Laserfiche
Updated February 22, 2017
asked on February 22, 2017

We are getting a lot of this query in the LF DB.

select sum(convert(bigint, d.txt_size)) + sum(convert(bigint, d.img_size)) + sum(convert(bigint, d.lft_size)) + sum(convert(bigint, d.loc_size)) from doc d join toc t on d.tocid = t.tocid where t.vol_id = @P1

 

We are using 9.1

Does anybody know what is triggering this query? Is very intensive and locking the rest of the LF sql statements.

 

Thanks

Gian

0 0

Replies

replied on February 22, 2017

This query is executed whenever a volume is first loaded (i.e. the first time a document in that volume is opened or accessed). The query efficiency was improved in version 10.

0 0
replied on February 22, 2017

Hi Robert,

I wonder why we got so many then. I can see the latest volume was created yesterday but we seem to got many of this queries.

We did a full power off / power on last weekend and since then we are having issues.
 

Would a power off re triggered all this queries?

Is strange because we never noticed this before.

 

Thanks

Gian

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

Sign in to reply to this post.

Details
Related Posts
Loading ...