Question

Long time to populate fields using dynamic fields - External Tables

Laserfiche

Updated November 25, 2015

asked on December 28, 2014

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. I have sorted the SQL table by all the columns ascending (same order that appears in the dynamic fields settings) and it did not help. The original table in SQL has over 11000 rows.

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?

0 0

Replies

replied on February 20, 2015

I am having the same problem.

0 0

replied on November 24, 2015

I don't see a response to this so I'm going to chime in - I was trying to find out if there's a limit to the amount of rows for dynamic fields?? The info I'm retrieving is straight-forward, but I must get input from the user and the list field is the cleanest, most effient way possible. There are 10,000+ rows in my table as well.

0 0

replied on November 25, 2015

There are a few questions needing answered before any suggestions can be presented. Is the database/table being referenced internally developed? How many columns does this table have? Have you tried running a query against this table/database outside of Laserfiche (SMSS)? If so, do you get the same performance?

0 0

replied on November 25, 2015

Chris,

Initially this was an Oracle table, but we didn't need all the columns and we were getting the 64/32 bit error (found out issue is with Oracle and we're not ready to update yet). We moved the necessary columns over to our data warehouse so I could reference. They get updated once per day (overnight) for any new additions.

4 columns of data were moved - 3 are actually needed; 4th is just the date of move

Running a query outside of Laserfiche much faster

Thanks,

Toyia

0 0

You are not allowed to follow up in this post.

Question

Question

Long time to populate fields using dynamic fields - External Tables

Replies

Sign in to reply to this post.