Fossil SCM

Notes On How To Locate SQL Statements That Are Candidates For Reuse

With this check-in, the --sqltrace option adds a comment at the end of each SQL statement of the form "Nth run" where N is the number of prior executions of the same statement. If you capture the --sqltrace output (which is on stderr instead of stdout) you can then search for all "1st run" queries and look for duplicates.

   ./fossil test-http --sqltrace <some-request.txt 2>sql-out.txt
   grep ' 1st run' sql-out.txt | sort | open -f