• Martyn James Russell's avatar
    Added ParentID and 2 indexes to improve GetStats performance. Removed · 93fefc73
    Martyn James Russell authored
    	* data/db/sqlite-service-types.sql: 
    	* data/db/sqlite-service.sql:
    	* data/db/sqlite-stored-procs.sql:
    	* src/libtracker-db/tracker-db-manager.c: 
    	* src/trackerd/tracker-daemon.c: Added ParentID and 2 indexes
    	to improve GetStats performance. Removed erroneous indexes which
    	were creating warnings when creating the databases. Added stored
    	proc to get all parent service type statistics (like Files,
    	Emails, Conversations, etc).
    
    	* src/tracker-applet/tracker-applet.c: Fixed stats order. This was
    	broken recently with the change to the stored procs.
    
    	* src/trackerd/tracker-main.c: Don't try to reset the stats in the
    	database when we reindex, we don't hold stats in the same place in
    	the same way now.
    
    svn path=/trunk/; revision=3113
    93fefc73
tracker-db-manager.c 56.9 KB