Re: [web2py] Fwd: Server slow

[Kenneth Lundström]

> Can you run the query directly against the db to compare? Do you have 
the debug tool displaying at the bottom of the page that shows how long 
he query took?

        t3=time.time()
        testar = db(db.tracker_person_product.id).select()
        t4=time.time()

         logging.info('query time: %s' % (t4-t3))

        --> query time: 47,7 seconds

If I run this:
        sql = db(db.tracker_person_product.id > 0)._select()
        t0=time.time()
        db.executesql(sql)
        logging.info('time to fetch %s' % (time.time()-t0))

        time to fetch: 16.8 seconds


Kenneth