During a run of monotone --debug push mt.xaraya.com:1500 'com.xaraya.sandbox'
i noticed this in the debug output: ...monotone: matching 'com.xaraya.sandbox' against 'com\.xaraya \.sandbox' excluding '$.^': included, not excluded: matches
monotone: finding items to synchronize: monotone: including branch com.xaraya.sandboxmonotone: prepared statement SELECT id, name, value, keypair, signature FROM revision_certs WHERE name = ? monotone: binding 1 parameters for SELECT id, name, value, keypair, signature FROM revision_certs WHERE name = ?
monotone: binding 1 with value 'branch' ...In our case that last select retrieves more than 30.000 records, of which almost all of them will be irrelevant.
Isn't there a way to call get_certs() in database.cc with the signature where the value is also included in the where clause of th query? The delay on the current query is *very* noticeable. From casual inspection it doesnt seem necessary to retrieve *all* certificates, but i'm still a bit lost in the woods in the code.
Thoughts? marcel -- Marcel van der Boom HS-Development BV -- http://www.hsdev.com So! webapplicatie framework -- http://make-it-so.info
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Monotone-devel mailing list [email protected] http://lists.nongnu.org/mailman/listinfo/monotone-devel
