Re: [sleuthkit-users] Slow Add Image Process Cause

[Simson G. <si...@ac...>]

Hi, Nassif. Could you repeat your experiment a few times and on different media? Please be sure to reboot your computer between each test.

All of the data are inserted in a single commit because the developers believed that this was the fastest way to add the data. If this is not the case, we would like to know.

Thanks!

Simson


On May 7, 2014, at 8:24 AM, Luís Filipe Nassif <lfc...@gm...> wrote:

> I have done one last test, because it was very strange to me that indexing meta_addr and fs_obj_id had not improved the parent_id lookup. We suspected that the indexes were not being used by sqlite, maybe because the whole data is not commited before add image process finishes (i am not a sqlite expert, is it possible?). So we inserted a commit for each 5.000 files added to database. The add image process time decreased from 1hour to 30min, so we think that the indexes were not being used.
> 
> Why add image process do not commit the data while it is being added to database?
> 
> Nassif