To simplify things and help our users to be more productive, we have archived the current forum and focus our efforts on helping developers on Stack Overflow. You can post new questions on Stack Overflow or join our Discord channel.
Hi, We are using the TableQuery to store the data in data base and its taking long time to save the same. Below is the code snippet we are using and it's loading the entire table data at line 2 (which is taking time) and filtering the required row by addContainerFilter later at line 3.
TableQuery query = new TableQuery( table, Database.getSolutionDatabase().getConnectionPool())
SQLContainer sqlContainer = new SQLContainer( query );
sqlContainer.addContainerFilter( new Compare.Equal( primaryKeyColID, solutionId ) );
Is there any alternate way to load only the required row data by passing the primary key , instead of loading the entire table data and adding the filter after that.
Is there any alternate to TableQuery with write option ? We have seen the FreeFormQuery, but it's read-only and we can't commit the changes to DataBase.