You should be using paging there is no point in query that much data at once you could never visually display it On Feb 6, 2012 11:36 PM, "LightOfMooN" <vladsale...@yandex.ru> wrote:
> I'm using loop for 100000 inserts just one time to insert 100k records > in database. > All next time I just try to get response. > And now in our project we have much more than 100k records, that can > be filtered and sorted by some dinamic conditions. > > On 7 фев, 12:27, Bruce Wade <bruce.w...@gmail.com> wrote: > > 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" <vladsale...@yandex.ru> 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 >