Thursday, October 10, 2024 Tip of the Day: Boosting Performance When Adding Many Table Records Product: R:BASE 11 Build: 11.0.1.41008 or higher Section: Commands Keywords: INSERT, LOAD, REINDEX, Index
Did you know that you can boost the performance when adding enormous amounts of table records using the INSERT and LOAD commands? The INSERT and LOAD commands were enhanced to enable rebuilding of non-constraint indexes "after" rows are added, rather than on a row-by-row basis. The new REINDEX parameter, added at the end of the commands, specifies that R:BASE will temporarily add the new rows without updating every non-constraint index row by row and only update constraint indexes row by row. When the new rows are done being added, the non-constraint indexes are then rebuilt. Example: INSERT INTO Declarations + (DecID, CredID, DeclarationType, DeclarationStatus, Declaration, PolicyID) + SELECT DecID, CredID, DeclarationType, DeclarationStatus, Declaration, PolicyID + FROM TempDeclarations WHERE PolicyID IS NULL REINDEX The new REINDEX keyword can be added to an INSERT command or to a LOAD command to enable rebuilding the non-constraint indexes after the rows are added. https://www.rbase.com/support/rsyntax/insert.html https://www.rbase.com/support/rsyntax/load.html Rebuilding the non-constraint indexes after the rows are added increases the overall speed when adding many rows to a table! Very Best R:egards, Razzak. R:BASE Technologies, Inc. https://www.rbase.com -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/184602246.13675.1728569511439%40email.ionos.com.
