what database are you using? you might need to add a custom index to your database.
try using db._lastsql to see the SQL that web2py executed, and then use the explain query plan feature of your database to look for possible index(es) to add. cfh On Wednesday, October 17, 2012 2:09:17 AM UTC-7, andrej burja wrote: > > hi > > i have table games and they have tags > i followed the example in the book and put tags in separate table > > now i want to show all games with all tags in the view: game.title, > games.instruction, game.tags > in fuction i have > for game in games: > equipment =[tag.name for tag in db(db.tag.game_id==game.id > ).select()] > game.f_equipment =', '.join(equipment) > > having more than 1000 games (games is row object with more than 1000 > entries), this is very slow. how can i make that faster? > > andrej > > --
