63 63 <br>
64 64 Note: We have already commands for the put and deltify operations, albeit undocumented, in the set of test commands.
65 65 </li>
66 66 </ul>
67 67
68 68 Miscellaneous:
69 69 <ul>
70 +<li>Add option to allow diverting the log output into a file, except for the progress reporting. Result is nice interactive log + progress, and a (relatively) small log file without all the unwanted progress numbers.
71 +</li>
70 72 <li>Go over the SQL statements and check that they have good query plans
71 73 </li>
72 74 <li>Go over the SQL statements and add comments where they are non-trivial.
73 75 </li>
74 76 <li>Currently some passes take quite a bit of time when their actual operation is already complete. It seems that sqlite is heavily working on committing a lot of changes (Most passes are wrapped into a single transaction). Consider ways of speeding this up.
75 77 <ul>
76 78 <li>Do our own transaction management? So that we can commit every X changes?.
77 79 </li>
78 80 <li>Should we disable synchronous operation? The state database is not that critical, i.e. it can always be regenerated. On the other hand, being able to be sure that we can restart from the interrupted pass is nice, and not possible if we got it corrupted by asynchronous operation. <b>Tabled for now, this is not yet critical</b>
79 81 </li>
80 82 </ul>
81 83 </ul>