search

scrollmapper / bible_databases

Bible versions and cross-reference databases.
976 stars 346 forks source link

SQL Server Specific Optimization #50

Closed DanielAdeniji closed 2 years ago

DanielAdeniji commented 3 years ago

Adding the following prefix will also help.

  1. Truncate table ( avoid duplicate )
  2. set nocount on ( reduce noise )
scrollmapper commented 3 years ago

I'll keep this in mind. Gonna leave this issue open for now.