Home » RDBMS Server » Performance Tuning » Image File Size (oracle 11 g)
Image File Size [message #635189] Tue, 24 March 2015 02:35
Messages: 36
Registered: July 2008
We have the below requirement which needs views and feedback from sizing, maintenance, accessibility and Process Speed etc.

Differentiating parameters
Image File Size
(SVG /JPG ) >1KB and < 100KB >100KB and <500KB >100KB and <1MB > 1MB

Processing Speed

I am done with Analysis for Oracle 11g.

Data used for analysis

For our 7M scans per day we have about 20% as doorstep, of those 5% will require photos of safe places, which are 2MP each.
Signature file format : SVG (Scalable Vector Graphics, XML)

Sizing data:
Photos: 7,000,000*.2*.05 = 70,000 photos of 2MB each = 14GB per peak day
Signature: 7,000,000*.2*.90 = 1,260,00 signatures of 10,000 bytes each = 12.6GB per peak day

Consideration for data store:
Database - Oracle 11 g

Now please help me in analysis for SAN /NAS


Previous Topic: Union (all) and outline hints
Next Topic: Bind variable for date type takes longer time in a query
Goto Forum:

Current Time: Mon May 27 22:20:34 CDT 2024