ExifTool + Java application on Debian - Scan All Nas

Started by omersorrenti, July 27, 2016, 04:17:20 PM

Previous topic - Next topic

omersorrenti

Hello everyone , I'm writing software in Java under Linux Debian environment that analyzes all nas direcotry (3TB) and write the result in a database .
In your opinion what is the best method to use exiftool for this scenario?
I need not consume too much CPU and i need high-speed
Thank you all for your cooperation

omersorrenti

I forgot to say that I have to analyze all types..... pictures , audio and video :-)
Currently the speed is 1 minute to 8.5GB...i need to increse my speed...
thanx

Phil Harvey

...where DIR is the name of a directory/folder containing the images.  On Mac/Linux/PowerShell, use single quotes (') instead of double quotes (") around arguments containing a dollar sign ($).

omersorrenti

Hi Phill, Thank you for your reply!
I have read "Improving Performance" section and it's very interesting.
But Unfortunately the link that you indicated about exiftool User experience not work..
"[One exiftool user documented a 60x speed increase by processing a large number of files with a single command instead of running exiftool separately on each file.] Also, the -execute option may be used to perform multiple independent operations with a single invocation of exiftool, and together with the -stay_open option provides a method for calling applications to avoid this startup overhead."

Reading the documentation I think the best way is to create a command with the parameters -execute and -stayopen ...
Can i ask you a little example of this approach?
I need to generate a .csv file because the next step for my project is a bulk insert in mysql DB.
Thanks a lot for your collaboration.
Omer

Phil Harvey

Hi Omer,

Quote from: omersorrenti on July 29, 2016, 05:34:27 PM
But Unfortunately the link that you indicated about exiftool User experience not work..

Thanks.  I'll see if I can fix this when I get a chance.  You should be able to find it on the wayback machine.

QuoteReading the documentation I think the best way is to create a command with the parameters -execute and -stayopen ...
Can i ask you a little example of this approach?

The exiftool application documentation explains it completely.

QuoteI need to generate a .csv file because the next step for my project is a bulk insert in mysql DB.

The -csv option is a strange beast.  I imagine you'll have some questions later...

- Phil
...where DIR is the name of a directory/folder containing the images.  On Mac/Linux/PowerShell, use single quotes (') instead of double quotes (") around arguments containing a dollar sign ($).