That is a lot of city :) Richard
On Tue, Feb 28, 2012 at 2:24 PM, Bruce Wade <[email protected]> wrote: > 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 >
