Hi. Some stuff has been recently merged in to GIT master, and will land into the next releases. Expect other improvements shortly.
----- Original Message ----- > From: "Michal Nanasi" <[email protected]> > To: [email protected] > Sent: Lunedì, 29 marzo 2010 17:38:31 > Subject: Performance problems > Hi all, > > F-spot is great software, but is terribly slow. I have in database > only 16806 photos and f-spot is really slow (everything, > just browsing, start, selecting tags,...). I ran some tests and > results were interesting. > > F-spot version: 0.6.1.5 (Ubuntu lucid). > > My PC > Processor: Intel(R) Celeron(R) M processor 1.50GHz > RAM: 2GB > > TEST 1: > f-spot --debug > 'QueryToTemp took 2,639268s: SELECT * FROM photos WHERE photos.id NOT > IN (SELECT photo_id FROM photo_tags WHERE tag_id = 2) ORDER BY time > ASC, filename ASC'. > It took 2.5 second to do a simple select. That means, that something > is wrong. > > TEST 2: > time sqlite3 .config/f-spot/photos.db 'SELECT * FROM photos WHERE > photos.id NOT IN (SELECT photo_id FROM photo_tags WHERE tag_id = 2) > ORDER BY time ASC, filename ASC;'> /dev/null > > real 0m1.131s > user 0m0.812s > sys 0m0.208s > > TEST 3: I imported data to mysql and see the results. > time (echo 'SELECT * FROM photos WHERE photos.id NOT IN (SELECT > photo_id FROM photo_tags WHERE tag_id = 2) ORDER BY time ASC, filename > ASC;' | mysql f-spot > /dev/null) > > real 0m0.880s > user 0m0.128s > sys 0m0.012s > > RESULTS: As you can see, the sqlite3 was significantly faster, and > mysql even more. I am not suggesting, that you should start using > mysql, but > f-spot is really slow. > Another example is > Query took 0,760874s : SELECT * FROM photoquery_temp_0 LIMIT 100 > OFFSET 9700 > Query took 1,355112s : SELECT * FROM photoquery_temp_0 LIMIT 100 > OFFSET 9900 > Query took 1,158414s : SELECT * FROM photoquery_temp_0 LIMIT 100 > OFFSET 9600 > Query took 1,176968s : SELECT * FROM photoquery_temp_0 LIMIT 100 > OFFSET 9500 > Query took 1,176931s : SELECT * FROM photoquery_temp_0 LIMIT 100 > OFFSET 9400 > > it took 1 second to return 100 rows from table? I now, that my > notebook is old, but this is really bad. f-spot is because of this > really unusable. > > So, the question is: Are you doing something about performance issues? > Because this looks like some bug (the select that use f-spot is really > slower, than using sqlite3). > > Thank you > > Michal Nanasi > > P.S.: I really like f-spot, it's great, but the more I use it, the > slower is it. > > > _______________________________________________ F-spot-list mailing > list [email protected] > http://mail.gnome.org/mailman/listinfo/f-spot-list -- Lorenzo Milesi - [email protected] YetOpen S.r.l. - http://www.yetopen.it/ Via Torri Tarelli 19 - 23900 Lecco - ITALY - Tel 0341 220 205 - Fax 178 6070 222 GPG/PGP Key-Id: 0xE704E230 - http://keyserver.linux.it -------- D.Lgs. 196/2003 -------- Si avverte che tutte le informazioni contenute in questo messaggio sono riservate ed a uso esclusivo del destinatario. Nel caso in cui questo messaggio Le fosse pervenuto per errore, La invitiamo ad eliminarlo senza copiarlo, a non inoltrarlo a terzi e ad avvertirci non appena possibile. Grazie. _______________________________________________ f-spot-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/f-spot-list
