Package: liferea Version: 1.4.18-1 Severity: important liferea does lots of database initialization while starting up; the cleanup includes checking for schema version, droping old stuff, creating new tables and indexes, and droping/creating triggers
the bad part, though, is the 'cleanup' part; it basically does a check to see if there are dangling item ids, and items without subscription; in my computer, a quite fast HP notebook, liferea takes 30 seconds to startup because of these queries it does in its database: INSERT INTO tmp_id SELECT ROWID FROM items WHERE ROWID NOT IN (SELECT item_id FROM itemsets) INSERT INTO tmp_id SELECT item_id FROM itemsets WHERE item_id NOT IN (SELECT ROWID FROM items) DELETE FROM itemsets WHERE comment = 0 AND node_id NOT IN (SELECT node_id FROM subscription) Most of the time these queries acomplish nothing but slow down liferea's startup. I believe it would be wise to not execute them on every startup; I already removed liferea from my GNOME's session startup, because GNOME was taking ages to become usable. Notice that a friend of mine did test his setup, which has almost the same number of items for me on his laptop, and although liferea did take some time to startup, it was considerably less than it took on my machine. We tested our disks performance with hdparm (which probably isn't conclusive, but anyway), and his was quite faster than mine, specially on cached disk reads. I'm setting the severity to important because I think this is plain unnaceptable for such a simple application, specially since what is being done is not accomplishing anything useful most times. Thanks, -- System Information: Debian Release: lenny/sid APT prefers unstable APT policy: (500, 'unstable'), (1, 'experimental') Architecture: i386 (i686) Kernel: Linux 2.6.26-1-686 (SMP w/2 CPU cores) Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/bash Versions of packages liferea depends on: ii gconf2 2.22.0-1 GNOME configuration database syste ii libatk1.0-0 1.22.0-1 The ATK accessibility toolkit ii libc6 2.7-15 GNU C Library: Shared libraries ii libcairo2 1.6.4-6.1 The Cairo 2D vector graphics libra ii libdbus-glib-1-2 0.76-1 simple interprocess messaging syst ii libgcc1 1:4.3.2-1 GCC support library ii libgconf2-4 2.22.0-1 GNOME configuration database syste ii libgcrypt11 1.4.1-1 LGPL Crypto library - runtime libr ii libglade2-0 1:2.6.2-1 library to load .glade files at ru ii libglib2.0-0 2.18.0-1 The GLib library of C routines ii libgnutls26 2.4.2-1 the GNU TLS library - runtime libr ii libgtk2.0-0 2.12.11-4 The GTK+ graphical user interface ii libice6 2:1.0.4-1 X11 Inter-Client Exchange library ii liblua5.1-0 5.1.3-1 Simple, extensible, embeddable pro ii libnm-glib0 0.6.6-2 network management framework (GLib ii libnotify1 [libnotify1 0.4.4-3 sends desktop notifications to a n ii libpango1.0-0 1.20.5-2 Layout and rendering of internatio ii libsm6 2:1.0.3-2 X11 Session Management library ii libsqlite3-0 3.5.9-5 SQLite 3 shared library ii libstdc++6 4.3.2-1 The GNU Standard C++ Library v3 ii libx11-6 2:1.1.5-2 X11 client-side library ii libxml2 2.6.32.dfsg-4 GNOME XML library ii libxslt1.1 1.1.24-2 XSLT processing library - runtime ii xulrunner-1.9 1.9.0.3-1 XUL + XPCOM application runner ii zlib1g 1:1.2.3.3.dfsg-12 compression library - runtime Versions of packages liferea recommends: ii curl 7.18.2-7 Get a file from an HTTP, HTTPS or ii dbus 1.2.1-3 simple interprocess messaging syst ii dbus-x11 1.2.1-3 simple interprocess messaging syst ii gwget 0.99-3 GNOME front-end for wget ii wget 1.11.4-2 retrieves files from the web liferea suggests no packages. -- no debconf information -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]