No it shouldn't.
On Sunday, 2 September 2012 19:18:25 UTC-5, Anthony wrote:
>
> 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.
>>>>
>>>
--
