Bootstrap a large data entity

Hi ,

     I have bootstrapped an entity with a size of 4000 rows in outsystems mobile, After finishing the bootstrap in the output page the performance of the app is affected badly, Is there is any solution for this problem. 

Hi Arun Kumar,

You should read this course, because maybe will help you:

Master Class on Best Practices and Timers: link

Regards,

Hi Arun, 

That is a really broad question. you need to tell us what is how you get the information from the db on that output page. If you add some prints would also be nice.

Regards,

Marcelo

Marcelo Ferreira wrote:

Hi Arun, 

That is a really broad question. you need to tell us what is how you get the information from the db on that output page. If you add some prints would also be nice.

Regards,

Marcelo

Hi Marcelo ,

                   Thanks for reply.

        The scenario is I need to auto populate the fifth value from the database, but the values in the database is too high since it has all the countries . So the application performance is affected (application stops)

Hi Arun,

You want to show the fifth record from an entity on that screen? And how are you getting the fifth record? you need to show us how do you get the values from the database

Regards,

Marcelo

Hi Marcelo,

                Here the entity has the attributes Like country,city,bank,branch and swift code, while selecting the country in first dropdown , the second dropdown should show the the city related to the country selected, and so on.

  Since  the  database size is 4000 lines the performance of the app is affected, if the entity has only 10-100 line then there is no issue.

 


Hi Arun,

There are a couple of problems in your code. First you are doing 4 queries to the same table SwiftCodes. Isn't possible to refactor that data model? Also if all those dropdowns have many elements that will slow the app.

Regards,

Marcelo