Though that shouldn't be adding 2-3Mb per request.
On Sunday, September 2, 2012 6:49:51 PM UTC-4, Massimo Di Pierro wrote:
>
> group_id=auth.add_group('manager', 'can access the manage action')
> auth.add_permission(group_id, 'access to manage')
> auth.add_permission(group_id, 'create', db, 0)
> auth.add_permission(group_id, 'read', db, 0)
> auth.add_permission(group_id, 'delete', db, 0)
> auth.add_permission(group_id, 'update', db, 0)
> auth.add_permission(group_id, 'select', db, 0)
> auth.add_membership(group_id, 7)
>
> should be
>
> if db(db.auth_group.role=='manager').isempty():
> group_id=auth.add_group('manager', 'can access the manage action')
> auth.add_permission(group_id, 'access to manage')
> auth.add_permission(group_id, 'create', db, 0)
> auth.add_permission(group_id, 'read', db, 0)
> auth.add_permission(group_id, 'delete', db, 0)
> auth.add_permission(group_id, 'update', db, 0)
> auth.add_permission(group_id, 'select', db, 0)
> auth.add_membership(group_id, 7)
>
> else you keep creating a new group and many memberships at every request.
>
> On Sunday, 2 September 2012 16:53:12 UTC-5, entropist wrote:
>>
>> from gluon.tools import Crud
>> crud = Crud(db)
>> auth.settings.login_next=URL('Gallery')
>> auth.settings.logout_next=URL('index')
>> auth.settings.register_next = URL('Gallery')
>> crud.settings.delete_next = URL('Gallery')
>>
>> group_id=auth.add_group('manager', 'can access the manage action')
>> auth.add_permission(group_id, 'access to manage')
>> auth.add_permission(group_id, 'create', db, 0)
>> auth.add_permission(group_id, 'read', db, 0)
>> auth.add_permission(group_id, 'delete', db, 0)
>> auth.add_permission(group_id, 'update', db, 0)
>> auth.add_permission(group_id, 'select', db, 0)
>> auth.add_membership(group_id, 7)
>>
>> @auth.requires_permission('access to manage')
>> def manage():
>> grid = SQLFORM.smartgrid(db.image)
>> return dict(grid=grid)
>>
>> def index():
>> images = db().select(db.image.ALL, orderby=db.image.title)
>> return dict(images=images)
>>
>> @auth.requires_login()
>> def Gallery():
>> form = SQLFORM(db.image)
>> if form.process().accepted:
>> response.flash = 'The image is uploaded!'
>> images = db().select(db.image.ALL, orderby=db.image.title)
>> return dict(images=images, form=form)
>>
>> def show():
>> image = db.image(request.args(0)) or redirect(URL('index'))
>> db.comment.image_id.default = image.id
>> form = crud.create(db.comment, next=URL(args=image.id),
>> message='Your comment is posted!')
>> comments = db(db.comment.image_id==image.id).select()
>> return dict(image=image, comments=comments, form=form)
>>
>> def delete():
>> crud.delete(db.image, request.args(0))
>> return dict()
>>
>> def list_items():
>> items = db().select(db.image.ALL, orderby=~db.image.votes)
>> counter = db(db.auth_user.id > 0).count()
>> return dict(items=items,counter=counter)
>>
>> def download():
>> return response.download(request, db)
>>
>> def vote():
>> item = db.image[request.vars.id]
>> new_votes = item.votes
>> l = item.voted
>> if auth.user.username not in l:
>> new_votes = item.votes + 1
>> l = l + [str(auth.user.username)]
>> item.update_record(voted=l)
>> item.update_record(votes=new_votes)
>> return str(new_votes)
>>
>> def user():
>> return dict(form=auth())
>>
>>
>> def download():
>> return response.download(request,db)
>>
>>
>> def call():
>> return service()
>>
>>
>> @auth.requires_signature()
>> def data():
>> return dict(form=crud())
>>
>> This is the default.py controller module. It seems each and every page
>> load causes the sqlite/db file to increase by 2-3 MB, though I'm cannot be
>> sure about any specific page.
>> Thanks in advance.
>>
>>
>> On Sunday, September 2, 2012 9:20:39 PM UTC+5:30, entropist wrote:
>>>
>>> Hello, I've just started with web2py and I'm trying to learn as much as
>>> I can to build functional web applications.
>>> I'm almost done with my first web2py app, it's a basic photo gallery
>>> where one can upload photos visible to other users, with functionalities
>>> like comment and like along with photo ratings etc.
>>> But I noticed a rather peculiar behavior, which slowed down my app
>>> tremendously. The storage.sqlite/storage.db file increases in its size
>>> mightily with every page load of my app!
>>> Within a few minutes of using the app, its size reaches around 1GB and
>>> goes onto 4-5GB after a while!
>>>
>>> With regard to the inner workings, I have images, users and comments
>>> databases. Besides, I have heavily tweaked the CSS file, added my own
>>> stylesheets and have used some extra jquery modules extensively.
>>>
>>> What could be the reason behind such a behavior and how can I get it
>>> fixed? Please guide.
>>>
>>
--
