As Leonel mentioned, index creation will be your best friend in this issue.
I have been using web2py during the last two years, and till now, I had no
concerns about database performance because I was working in intranet
applications without a big volume of data.
In the latest project we had a
In model I have this
db.define_table('amc_details',
Field('amc_id','reference
amc_master'),
Field('jcod',
type='string',required='True',notnull='True',length=10),
Field('jobdesc',type='string',required='True',notnull='T
Sorry. I am able to do it. In view new_contract.html I have now this.
{{extend 'layout.html'}}
New Contract
{{=form}}