Is VARCHAR2 size optimization worthwhile ?

Hi, I've recently commissioned a hosted system from a developer who has recommended using J2EE and Oracle. Their J2EE system is quite slick and works very well in preproduction. It uses annotations to generate the Oracle tables on the fly during deployment. On examination of the table structures that it's generated though, it's defaulted all of the VARCHAR2 definitions to 255 characters. On asking the developer about this, his argument is that storage is pretty much a commodity nowadays so it wasn't worth the trouble of defining and optimizing every field (there are hundreds). Furthermore VARCHAR2 only uses the number of bytes required to hold the value stored and wouldn't take up the full 255 anyway, so 255 is just a max value. I'm concerned that this non-optimized table definition might have a performance impact when we go live and I'm considering engaging in an exercise to go through every VARCHAR2 field and tune it to the size of the data that will be stored. What are people's opinions here ?

Questions by hotsnot

Showing Answers 1 - 3 of 3 Answers

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions