That page loads very fast. All that queries (more then 100) don't execute on one pages, therefore I asked what is thats queries. All of them contains in my app but in different functions. I use cache for first 8 queries like that: if not 'edu_lvl' in globals(): def getConst(): edu_lvl = {rec.id:rec.name for rec in db(db.s_edu_level).select(db. s_edu_level.id,db.s_edu_level.name)} edu_inst={rec.id:rec.name for rec in db(db.s_edu_inst).select(db. s_edu_inst.id,db.s_edu_inst.name)} hostel={rec.id:rec.name for rec in db(db.s_hostel).select(db. s_hostel.id,db.s_hostel.name)} medal={rec.id:rec.name for rec in db(db.s_medal).select(db.s_medal. id,db.s_medal.name)} region={rec.id:rec.name for rec in db(db.s_region).select(db. s_region.id,db.s_region.name)} country={rec.id:rec.name for rec in db(db.s_country).select(db. s_country.id,db.s_country.name)} kladr_type={rec.id:rec.name for rec in db(db.s_kladr_loc_type). select(db.s_kladr_loc_type.id,db.s_kladr_loc_type.name)} vuzName=db(db.t_const.name == 'VUZ_KR').select(db.t_const.text). first() return edu_lvl,edu_inst,hostel,medal,region,country,kladr_type, vuzName
edu_lvl,edu_inst,hostel,medal,region,country,kladr_type,vuzName = cache. ram('consts', lambda: getConst(), time_expire=60*60*24) Moreover that queries belong different users. It's reason why quantity of them more then 100. I thought that it's queries for period of time. About my last questions, I wanted to write: are there way to put buttons in row like on picture. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/e4a26ab2-3d30-4931-b418-dc72e7348635%40googlegroups.com.