Bug 24451 - Web Inspector, HTML5 Databases: Selecting Tables loads entire table into main memory, even 1GB+ tables.
Summary: Web Inspector, HTML5 Databases: Selecting Tables loads entire table into main...
Status: RESOLVED DUPLICATE of bug 46656
Alias: None
Product: WebKit
Classification: Unclassified
Component: Web Inspector (show other bugs)
Version: 528+ (Nightly build)
Hardware: All All
: P3 Normal
Assignee: Nobody
URL:
Keywords: InRadar
Depends on:
Blocks:
 
Reported: 2009-03-08 03:06 PDT by Michael Edgar
Modified: 2018-08-23 13:09 PDT (History)
5 users (show)

See Also:

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 an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Michael Edgar 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.
Comment 1 Michael Edgar 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.
Comment 2 BJ Burg 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.
Comment 3 Radar WebKit Bug Importer 2014-01-12 15:49:57 PST 
<rdar://problem/15801446>
Comment 4 BJ Burg 2018-08-23 13:09:00 PDT 

*** This bug has been marked as a duplicate of bug 46656 ***