[web2py] model label and comment stored at database level (minimizing the number of queries)

[Jean-Guy]

Hello,

I would like to use data dictionnary stored in database to define field 
label and comment. The comment is used to provide help to users...

I am wondering what could have the smaller impact on database performance :

1) create a python dictionnary like this :

dictname = {fieldlablename:db().select()}

in it own model... Then use the dictname['fieldlablename'] key in :

db.define_table('atable',
    Field('field1'),
    Field('field2',label=dictname['fieldlablename']))

OR

2) Just :

db.define_table('atable',
    Field('field1'),
    Field('field2',label=db().select()))

I expect that my first choice will result in the reducing request to 
database server and not overwrite the server database by database 
queries each time a form is called by a controller function... Is that 
correct?

Regards

Jonhy