SmartObjects with a lot of records in DB problem loading


So, I have a Oracle database and I have tables with lot of records (1000, 5000 or 10000). I created SmartObjects with Service Tester tool and I am trying to use these SOs on Smartforms (K2 Designer). I can make a view based on this SO with no problems. But, when I try to edit this view (item view or list view - it doesn't matter), it keeps loading forever. It takes a lot time to initialize this view. 

 

I tried to find a workaround, but I was unable to find a solution, altough I believe that there is a way to make life easier in Smartforms using Smartobjects based on tables with lot of records.

 

I would appreciate any help.


2 replies

Userlevel 5
Badge +16

Hi  @MysticAladin,


 


Have a look at the following thread:


 


http://community.k2.com/t5/K2-blackpearl/Can-not-edit-form-rule-or-save-changes/td-p/81004


 


Hope that helps

Badge +8

MysticAladin,

 

I have had issues similar to this. One thing I do is to make sure my list views are not calling the list method when the form loads. On list views on the General tab there is a check box that says "Call this method when form loads.". I uncheck this box and call the method when I need to call the list method. 

 

 

When initializing the form is there a rule that calls the list method for a control? Is it reading a smartobject and then filtering the data or is it calling the data required for that control?

 

Thanks,

Bryan Peters

Reply