Demo optimized advance sql with Paging

Stable Version 1.0.0 (OutSystems 10)
Published on 22 November 2018 by 
Created on 22 November 2018
Details
In case of paging with Table Record Aggregates fetching records according to line count from database but in case of advance sql it is fetching all records from database every time. In this demo I done the implementation so that advance sql is also fetching data as per line count of table record(same way Aggregates in case of paging). It will improve the performance of advance sql.
Read More

In case of paging with Table Record Aggregates fetching records according to line count from database but in case of advance sql it is fetching all records from database every time. In this demo I done the implementation so that advance sql is also fetching data as per line count of table record(same way Aggregates in case of paging). It will improve the performance of advance sql.

Reviews (0)
Category
Machine Learning, Applications
Tags
Support Options
This component is not supported by OutSystems. You may use the discussion forums to leave suggestions or obtain best-effort support from the community, including from Shashi kant Shukla who created this component.
Dependencies
Demo optimized advance sql with Paging has no dependencies.
Requirements
Platform
10.0.0.402
Database
All
Stack
All
Component Consumers
No consumers yet.
Weekly Downloads 
Related Components
Infosistema DMM
Infosistema Solutions
Infosistema Data Migration Manager (DMM) - With DMM you reduce costs by saving hundreds of hours building custom scripts, increase quality and allow unprecedented flexibility in managing your data. DMM enables data migration across OutSystems environments or servers (v9 or v10) using a simple user interface without the need of building custom scripts. It also supports features like data anonymization and data scramble, essential to comply with GDPR.
348
Chat
Hélio Dolores
Mobile and Inline Chat for OutSystems' Applications (uses node.js)
847
Survey
Sérgio Oliveira
Survey, as the name implies, is an application to create and manage Surveys, which can be answered by a specified group of users or by everyone who access the application, including anonymous users.
632
More from Shashi kant Shukla
GenericImportFiles
Shashi kant Shukla
We can achieve the following functionalities with this extension: 1. GetFileExtension 2. GetXLSSheetsNames 3. GetXLSXSheetsNames 4. ImportCSV 5. ImportTabDelimited 6. ImportXLS 7. ImportXLSByColumns 8. ImportXLSHeader 9. ImportXLSX 10. ImportXLSXByColumns 11. ImportXLSXBySheetName 12. ImportXLSXHeader
118
BinaryData
Shashi kant Shukla
Convert binary to bytes
134
WebPatternsWith10Tabs
Shashi kant Shukla
Since web patterns Tabs provide only 5 tabs so if there are a requirement more than 5 tabs I extended Tabs to handle 10 tabs.
33