[Webkit-unassigned] [Bug 10532] Noticable delay on startup due to new icon database

[bugzilla-daemon at opendarwin.org]

http://bugzilla.opendarwin.org/show_bug.cgi?id=10532


beidson at apple.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |ASSIGNED




------- Comment #1 from beidson at apple.com  2006-08-23 23:18 PDT -------
Note - this occurs only when the aggregate of the user's history and bookmarks
has a large number of PageURLs to retain on startup - in Mark's case, it seems
to be about 1000.  If this count is negligible, startup times won't be
affected.  If it's larger, the delay will grow linearly.

The cause is known (iconURLForPageURL query being called on each of the
PageURLs serially) and a few suspected fixes are being considered.

One is to be *much* more intelligent with SQL queries - prepare them once,
rebind parameters, and run them.  This is instead of preparing, binding,
running, and finalizing each time.

Another is to find a way to aggregate all of these startup queries.


-- 
Configure bugmail: http://bugzilla.opendarwin.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.