830757 - Jank from main thread SQL degrades download experience

Status: RESOLVED DUPLICATE of bug 825588

(Core Graveyard :: File Handling, defect)

Description

[Vladan Djeric (:vladan)]

I hit jank whenever I open a download with an external app. For example, when I click on the video attached to bug 794246, I get roughly a 1 second UI pause.

Profile shows we're doing main thread SQL from nsDownload::UpdateDB:

http://people.mozilla.com/~bgirard/cleopatra/#report=ed51003641c2c93254aa1596b829519e0c293ab9

I think this is the offending SQL:

UPDATE moz_downloads SET tempPath = :tempPath, startTime = :startTime, endTime = :endTime, state = :state, referrer = :referrer, entityID = :entityID, currBytes = :currBytes, maxBytes = :maxBytes, autoResume = :autoResume WHERE id = :id /* downloads.sqlite */

P.S. Ignore the incorrect "shutdown" markers & the main thread I/O from the DropBox extension in the profile.

Comment 1

[Josh Matthews [:jdm]]

See bug 699854.