1.

Does Strict Mode Impact Performance?

Answer»

The intensive validation of input data that some settings requires more TIME than if the validation is not done. While the performance impact is not that GREAT, if you do not require such validation (perhaps your APPLICATION already handles all of this), then MySQL gives you the option of leaving STRICT mode disabled. HOWEVER, if you do require it, strict mode can provide such validation.

The intensive validation of input data that some settings requires more time than if the validation is not done. While the performance impact is not that great, if you do not require such validation (perhaps your application already handles all of this), then MySQL gives you the option of leaving strict mode disabled. However, if you do require it, strict mode can provide such validation.



Discussion

No Comment Found