[Monotone-devel] Unnecessary performance hit on push?

[Marcel van der Boom]

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.sandbox
monotone: 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