Bug 24451

Summary: Web Inspector, HTML5 Databases: Selecting Tables loads entire table into main memory, even 1GB+ tables.
Product: WebKit Reporter: Michael Edgar <michael.j.edgar>
Component: Web InspectorAssignee: Nobody <webkit-unassigned>
Status: RESOLVED DUPLICATE    
Severity: Normal CC: bburg, emacemac7, graouts, inspector-bugzilla-changes, webkit-bug-importer
Priority: P3 Keywords: InRadar
Version: 528+ (Nightly build)   
Hardware: All   
OS: All   
Attachments:
Description Flags
Screenshot of the memory out of control. none

Michael Edgar
Reported 2009-03-08 03:06:44 PDT
If you have an HTML 5 database, and select one of its tables in the Web Inspector, it then proceeds to load every single row to display it. If that table is very large (500MB+), this can cause major system performance issues very rapidly. My use-case is an e-mail web-app with 800MB of downloaded e-mails stored offline - this caused my computer to become near-unusable until I managed to kill WebKit.
Attachments
Screenshot of the memory out of control. (199.98 KB, image/png)
2009-03-08 03:14 PDT, Michael Edgar 		no flags
Details
View All Add attachment proposed patch, testcase, etc.
Michael Edgar
Comment 1 2009-03-08 03:14:48 PDT
Created attachment 28403 [details] Screenshot of the memory out of control. I re-created the issue and snapped a shot of the activity monitor.
Blaze Burg
Comment 2 2014-01-12 15:49:42 PST
I don't think the expected use case of HTML5 databases is to store 1GB tables. However, we shouldn't be doing `SELECT * FROM ...` anyway.
Radar WebKit Bug Importer
Comment 3 2014-01-12 15:49:57 PST
<rdar://problem/15801446>
Blaze Burg
Comment 4 2018-08-23 13:09:00 PDT
*** This bug has been marked as a duplicate of bug 46656 ***
Note You need to log in before you can comment on or make changes to this bug.