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

Question

Question

Data Source Row Limit?

Forms
Updated September 7, 2021
asked on September 2, 2021

Is there a limit to the amount of rows LF forms can parse when using a SQL view as a data source?  I'm using a SQL view that combines 5 tables of like columns using UNION.  I can see all the rows when running the query in SQL studio, but forms doesn't seem to be able to pull them all down. 

 

Thanks!

0 0

Replies

replied on September 7, 2021

There's no built-in limit, however, you could run into "functional" limits in the browser depending on how much data the form needs to retrieve and load.

The more rows and columns you have, the more elements the form needs to add to the DOM and populate, and once you get past a certain number it can really bog down browser/JavaScript performance.

How many rows does the view return in SSMS?

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

Sign in to reply to this post.

Details
Related Posts
Loading ...