[Webkit-unassigned] [Bug 96862] [Qt][WK2] REGRESSION(r128623): It made layout tests extremely slow

[bugzilla-daemon at webkit.org]

https://bugs.webkit.org/show_bug.cgi?id=96862





--- Comment #7 from Zan Dobersek <zandobersek at gmail.com>  2012-09-27 02:29:15 PST ---
Well, here's the breakdown of what's slow (nothing surprising):
In DatabaseTracker::setQuota:
- opening the database[1] takes around 0.38 seconds
- inserting the origin into the database[2] takes around 0.18 seconds
- the whole method is executed in around 0.5 seconds (too long!)

In DatabaseTracker::openTrackerDatabase[3], the two biggest time consumers are:
- Origins table creation, takes around 0.18 seconds
- Databases table creation, takes around 0.2 seconds

In SQLiteStatement::executeCommand[4] when creating the Databases table:
- the step()[5] call takes most of the time

Just to note, I'm running the tests on Ubuntu 12.10 and the problems are occurring with both SQLite 3.7.13 and 3.7.14. Interestingly the GTK WK2 builder is running Debian, either testing or unstable distribution, but in any case SQLite 3.7.13 or 3.7.14 would be used[n], so the problem is probably not originating directly from SQLite.

[1] http://trac.webkit.org/browser/trunk/Source/WebCore/Modules/webdatabase/DatabaseTracker.cpp#L665
[2] http://trac.webkit.org/browser/trunk/Source/WebCore/Modules/webdatabase/DatabaseTracker.cpp#L670
[3] http://trac.webkit.org/browser/trunk/Source/WebCore/Modules/webdatabase/DatabaseTracker.cpp#L106
[4] http://trac.webkit.org/browser/trunk/Source/WebCore/platform/sql/SQLiteStatement.cpp#L136
[5] http://trac.webkit.org/browser/trunk/Source/WebCore/platform/sql/SQLiteStatement.cpp#L95
[n] http://packages.debian.org/search?keywords=sqlite3&searchon=names&suite=all&section=all

-- 
Configure bugmail: https://bugs.webkit.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.