<!DOCTYPE html><html><head><title></title><style type="text/css">p.MsoNormal,p.MsoNoSpacing{margin:0}</style></head><body><div style="font-family:Arial;">JMAP slow query performance:<br></div><div style="font-family:Arial;"> * lots of discussion of why NOT in:Mailbox is really slow<br></div><div style="font-family:Arial;"> * Bron will build out a test user using the enron dataset to see if we can easily debug in dev<br></div><div style="font-family:Arial;"> * will also get a callgrind dump from a production user who has issues with both AJAX and JMAP<br></div><div style="font-family:Arial;"> * might try to build an array of folder numbers in conversations.db to "yes, include", "no, exclude" or "not mentioned" at each tree level in the search expression for quick filtering<br></div><div style="font-family:Arial;"><br></div><div style="font-family:Arial;">Ken:<br></div><div style="font-family:Arial;"> * have migration tool almost done<br></div><div style="font-family:Arial;"> * need to add support for tiered Xapian indexes<br></div><div style="font-family:Arial;"> * added namelocks to ensure nobody reads a middle state<br></div><div style="font-family:Arial;"> * can give a mailbox or an entire user<br></div><div style="font-family:Arial;"> * start work on the Vacation JMAP support. We need to figure out what to do with custom scripts!<br></div><div style="font-family:Arial;"> - probably add an "include" to the end of the current active script<br></div><div style="font-family:Arial;"> - create an empty active script if there isn't one<br></div><div style="font-family:Arial;"> * for testing the by-UUID code, we'll try replicating to a new machine with the new code and see if that works.<br></div><div style="font-family:Arial;"><br></div><div style="font-family:Arial;">Robert:<br></div><div style="font-family:Arial;"> * closed out Cyrus 3.2 issues from github last week<br></div><div style="font-family:Arial;"> * default values - being returned on get<br></div><div style="font-family:Arial;"> * should we return empty string for properties of type string that don't have defaults?<br></div><div style="font-family:Arial;"> * refactored JMAP language indexing, would like to get it on the branch with attachment indexing.<br></div><div style="font-family:Arial;"> * with CalConnect coming close, running out of time. Need to work on JSCalendar first.<br></div><div style="font-family:Arial;"> * for JSContact, there's somebody interested in implementing it already! They'll have to expect lots of rewrites before it's standard.<br></div><div style="font-family:Arial;"><br></div><div style="font-family:Arial;">Bron:<br></div><div style="font-family:Arial;"> * Been working on index upgrade/downgrade for 3.2<br></div><div style="font-family:Arial;"> * readonly conversations support to mailbox_open_iwl inversion - changed to abort immediately rather than later when conversations DB write failed - needed to fix a bunch of places which were doing that.<br></div><div style="font-family:Arial;"><br></div><div style="font-family:Arial;"><br></div><div id="sig56629417"><div class="signature">--<br></div><div class="signature"> Bron Gondwana, CEO, FastMail Pty Ltd<br></div><div class="signature"> brong@fastmailteam.com<br></div><div class="signature"><br></div></div><div style="font-family:Arial;"><br></div></body></html>