Loading SQL Database to a table with just about 300 rows is really slow about 20 minutes in IE and 5mins in chrome and the Page unresponsive prompt keeps popping out.
Please give us grid view control!!!
hey Maxwell,
I've faced a similar problem, if not worse, while loading more than 3000 rows directly from SQL Database.
I've found a way to deviate from this problem by loading all these rows of data into dropdown list. All 3000 rows were loaded successfully with no delay.
Try doing the same thing and then populating your table with the convenient rows following your selection in the dropdown Field, 'If' it's feasible in your case.
Mainly, loading a large number of rows into Forms creates lagging problems. Maybe a better hardware configuration might fix your issue. But it's not a general solution for such problems
I hope they fix this issue in LaserFiche 10.4 !
I have about 8 columns, is this means I have to create 8 dropdown list and use javascript to read each item and populate a custom html table ?
Thank you!
Hey Maxwell,
At the time, i had a table to show in forms that contains cities with their corresponding countries.
Like i already told you i had an sql table with 3000+ rows in it.
so what i did was i created a drop down list containing all the cities ( all 3000+ of them) in a way that when i select a certain value from that dropdown list the corresponding values appear and populate my table.
That was convenient for my situation and helped avoid the delay.
I was just sharing how i worked around the problem
try to run the same Form or Process if possible on another machine which is considered better in performance. If the results were better maybe a simple hardware modification may solve this issue.
Regards
Hi Joseph,
In my case I have to display a table with 8 columns and rows of data from SQL. I have to display the form in a report format changing Text boxes with a label using jquery.
Thanks,
Max
hey Maxwell,
i personally recommend to check the performance of your form using another faster machine (PC, laptop..). This might lessen the output delay about 10-20% (just assuming)
But it will not solve the problem as i previously said.
Try opening a case with laserfiche about this issue.
Regards
Thank you Joseph! I do have pc with 32gb of ram and i7 4 cores. I guess I just have to open case with LF