I have a Sql querry which joins some tables and it provide the result. It taking one minute to load the data in grid and also in API. I have use pjs.parallelqueres method, still it is taking longer time to load.
Help me on improve the performance.
Hello aravintht,
I am sorry to hear that you are experiencing performance issues when running your SQL query. I wanted to ask if you could provide some additional information on your issue? Is this a public space you can share with us so that we can take a look at exactly what you are doing? If not could we ask on how much data you have in your tables you are querying? I also wanted to ask how you isolated the issue so that you know that it is specifically the query that is causing the delay? The more information you can provide on the issue the better we will be able to assist you!
Thanks,
Kyle Law
Technical Support Specialist
Profound Logic Software
Hi Klaw,
Is there any way to load the grid dynamically.
Asynchronous loading of grid is possible?
Thanks,
Aravinth
Hello Aravinth,
Yes you can load a grid dynamically, and you can load the grid Asynchronously when using the database driven properties of the Grid widget. I created an example program using the grid template example, but instead of loading the grid using grid.replaceRecords() I specified the ‘database table’ and ‘database fields’ properties of the Grid widget so that it can generate the SQL statement at runtime (client side) to retrieve the records.
You can find that example here: https://noderun.com/ide/klaw/example-database-driven-grid/
Alternatively, If you still want to retrieve the records on the server side, you could try creating a web service that supplies the grid data you need, and then use pjs.sendRequest() API to call it.
I hope that helps to answer some of your questions, and if you have any other questions concerns, please let us know and we will be happy to help!
Thanks,
Kyle Law
Technical Support Specialist
Profound Logic Software