WOW I didn't even think about that. It is probably the cities causing the problem because there is over 1 million cities and on every view that uses it in my site I use ajax to get only the provinces and cities related to the other selection.
On Tue, Feb 28, 2012 at 11:21 AM, Massimo Di Pierro < [email protected]> wrote: > Do you have a many provinces in database? > > IS_IN_DB(db, db.provinces.id, '%(name)s')) > > may be trying to build a huge dropdown > > On Feb 28, 12:17 pm, Bruce Wade <[email protected]> wrote: > > Hi, > > > > Lately I have found the appadmin completely freezing my entire computer. > > Even when I try to view the errors log my system hangs. Deleting all > > contents from the errors folder fixes this problem, however also defeats > > the purpose of having error logs :D > > > > Another issue I have a small not very complex table > > > > db.define_table('ads', > > Field('member_id', db.user_account), > > Field('points', 'integer', default=0), > > Field('url', unique=True, requires=[IS_NOT_IN_DB(db, 'ads.url'), > > IS_URL()]), > > Field('language', requires = IS_IN_DB(db, db.languages.code, > > '%(language)s')), > > Field('location'), > > Field('country', 'reference countries', requires = IS_IN_DB(db, > > db.countries.id, '%(name)s')), > > Field('province', 'reference provinces', requires = IS_IN_DB(db, > > db.provinces.id, '%(name)s')), > > Field('city', 'reference cities', requires = IS_IN_DB(db, > db.cities.id, > > '%(name)s')), > > Field('accepted', 'boolean', default=False), > > Field('viewable', 'boolean', default=True), > > Field('updated_at', 'datetime', default=request.now), > > Field('added_at', 'datetime', default=request.now), > > migrate=False > > ) > > > > Which has 328 entries (very small amount) view this db table's records > with > > the admin app isn't a problem. However when I then click on an ID for a > > record after waiting for a minute my entire OS locks up. Any suggests on > > where to look about this major bottle neck? > > > > -- > > -- > > Regards, > > Bruce Wadehttp:// > ca.linkedin.com/in/brucelwadehttp://www.wadecybertech.comhttp://www.warplydesigned.comhttp://www.fitnessfriendsfinder.com > -- -- Regards, Bruce Wade http://ca.linkedin.com/in/brucelwade http://www.wadecybertech.com http://www.warplydesigned.com http://www.fitnessfriendsfinder.com
