Question

Long time to populate fields using dynamic fields for DES values - External Tables

Laserfiche

Updated June 25, 2015

asked on June 24, 2015

Hi all,

When uploading files into Laserfiche, I have created a template using dynamic fields. I am trying to allow users to select a value from a drop-down list (all stored in a table in SQL), and based on its value populate, client name, code, item code, name, all these in the same table. By only selecting one dopdown list, the rest of the fields should be populated.

The problem is that, once I select the fist field, it is taking more than 10 seconds to auto-populate the rest of the fields.

The main problem is the delay between the selection and when the fields get populated. Any suggestions either from Laserfiche or SQL server to fix this?

We are currently using MS SQL Server 2008R2 and Laserfiche Client v 9.2.0.451

any suggestions.

thanks

0 0

Replies

replied on June 24, 2015 • Show version history

There are a lot of factors that go into lookup performance.

Run the following query in SQL Management Studio and note how long it takes:

SELECT *
FROM your_table_name
WHERE any_column = 'some_value'

The asterisk grabs all column data. You can be more specific too. For example, if you were looking to find the vendor for a particular invoice, you would do:

SELECT vendor_name
FROM invoices
WHERE invoice_number = '123'

0 0

replied on June 24, 2015

Hello Ege,

The result is instantaneous from the sql query.

My concern is that it is impacting our flow of work and it has pop up just like that on our system.

We have not made any changes to our system lately.

Is there any other reasons why it is so.

0 0

replied on June 25, 2015

Your next step would be to trace the queries run by Laserfiche Server using a tool like SQL Profiler. That might point you to the root cause.

By the way, it is always a good idea to be on the latest version. If you get the chance, upgrade the LF Server and Client to 9.2.1 as well.

0 0

replied on June 25, 2015

Hello Ege,

Thanks for the tips concerning SQL Profiler.

Since i'm new to the software, can you please just advice me which events i should monitor for me to get a picture what can cause this lagging for the DES values to load.

Thanking you in advance

0 0

You are not allowed to follow up in this post.

Question

Question

Long time to populate fields using dynamic fields for DES values - External Tables

Replies

Sign in to reply to this post.