Ifmx Nosql and key name: impact of the length of the 'key' name

Hi Friends, Interesting ( according to me at least) question about best practices on NoSQL implementation in our beloved HDBMS (hybrid DBMS) When you handle a NoSql Document, you have inside it a number of key/value pairs. OK Now when it is time to give names to the 'keys': what is the impact of giving a 'long' name to the key on storage consumed ? For instance, if i say something like {"myverylongkeynamenumberone":"XXXX","myverylongkeynamenumbertwo":27} will it take more space (and if yes what are the numbers?) in my dbspace, as per compared with {"mvskn1":"XXXX","mvskn2",27} I know that the data is stored as BSON, this binary, but is there any compression mechanism such as a dictionary of the key names for instance, such as the ifmx compression does ? The idea is to start with significant names but avoiding unuseful space comsumption ... Any hints ? Thanks in advance Eric ------------------------------ [eric] [Vercelletto] [] [Founder] [kandooerp.org] [Pont l'Abbé] [France] [+33 626 52 50 68] Disclaimer: My own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. ------------------------------ #Informix

No dictionary Eric. Each BSON item contains the key names for each field that exists in that item and only those fields. So, yes, longer names take up more space on disk and will affect performance. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.

Sounds clear, Thanks Art, I will proceed accordingly Have a great Saturday! Eric