Performance and settings

To keep our database nice and tidy, following helper methods are added

Increase performance during batch operations

SYS_CTX_UPDATE allows you to change the state of the database during a transaction to speed up operations by disabling functionalities

Procedure SYS_CTX_UPDATE
IN_BATCH_UPDATE: when set, the clients are not informed of the changes
IN_DISABLE_LOG: when set to true, X-Tables are not recorded
IN_DISABLE_SYNC: when set to true, changed will not be synchronized
IN_SYNC_RUNNING: Simulate synchronization running
IN_DISABLE_SEARCH: when set to true, search tables aren’t updated
IN_DISABLE_ADDRESS_VALIDATION: when set to true, address validation records aren’t insert

Remember to fix what ever you disabled by rebuilding search, reuploading database, …

Constants for settings

SET_IS_CLUSTER: returns true when cluster is active
SET_START_OF_DAY: returns time when workday starts
SET_TAX_INCLUSIVE: returns true when tax is inclusive

SMS-Timing and BMI Leisure are brands of B&MI NV. We offer an all-in-one reliable software suite, covering all aspects of your karting & entertainment business, including strategic advising, and marketing. We help you deliver fun, relaxing, and entertaining experiences to your visitors that will keep them coming back for more!

Our system includes a comprehensive POS system, CRM management, online booking & website shop for family entertainment centers all over the globe.

More information?

Check out our website: BMI Leisure and SMS-Timing

Need more help with this feature? Click here:  24/7 Support service

Check out other updated features here: devblogs 

Remember also to check our Marketing blogs for some inspiration! 

This site uses Akismet to reduce spam. Learn how your comment data is processed.