You are using a for loop with 100000 inserts it is the for loop holding you
up not web2py. Plus who in their right mind would code something like that
in production
On Feb 6, 2012 11:24 PM, "LightOfMooN" <[email protected]> wrote:
> Hi
> Just download web2py, run it and go to edit welcome app.
>
> in db.py:
> db.define_table('mytable',Field('myfield','string'))
>
> in controllers/default.py:
> def index():
> if request.vars.add_rows:
> for i in xrange(100000):
> db.mytable.insert(myfield='')
> rows = db(db.mytable.id>0).select()
> response.flash = "Welcome to web2py!"
> return dict()
>
> in controllers/index.html:
> {{extend 'layout.html'}}
> <form method="POST">
> <input type="submit" name="add_rows" value="add 100k rows" />
> </form>
>
>
>
> Let's test it.
> Click on "add_rows" button to insert 100000 rows in database.
> Then reload page.
> There are just one query, that gets us one set of 100k rows.
> Time to process query is less than 100ms, but page loads 5-6s!
> Nothing passed to the view.
>
> So, my question is:
>
> Is web2py can be used in production for big sites, or just for small-
> home-sites?
> thx
>
