(dormant account) Assignee
	Description • 13 years ago

This can cause significant browser stalls, needs to be fixed asap.

	(dormant account) Assignee
	Comment 1 • 13 years ago

I added a MOZ_SQLITE_WEBAPPS_SYNC_MAIN_THREAD_MS telemetry probe and we fsync a lot from webpages.

	(dormant account) Assignee
	Comment 2 • 13 years ago

bug 704933 will(hopefully) take care of fsyncs

	(dormant account) Assignee
	Comment 3 • 13 years ago

This bug is blocked on data from bug 704933 to see how much effort we need to sink into fixing this

	Honza Bambas (:mayhemer)
	Comment 4 • 13 years ago

IMPORTANT NOTE:
During next week or two I want to start porting the DOM storage back-end to LevelDB to see how we improve.  There are other important bugs to get fixed with that, not just performance issues.

	(dormant account) Assignee
	Comment 5 • 13 years ago

Just got some numbers from about:telemetry addon on this(https://blog.mozilla.com/tglek/2011/12/13/slow-sql-tracking/).

I'm on a fast ssd.
1900ms to run INSERT OR REPLACE INTO webappsstore2 SELECT * FROM webappsstore2_temp WHERE scope = :scope;

	Dietrich Ayala (:dietrich)
	Comment 6 • 12 years ago

Duping against bug 627635 since that's where the discussion and work is being done. Will carry over the blocking of bug 701872.