> Please tell us more about the setup. Are the three instances behind
running on the same server?
Yes.
> why three? What do they do?
One is production, one is testing and last one is development. I had two
instances running on a virtual server before and it worked fine.
> This is not normal but I suspect the problem is with database.
> Did you set DAL(...,pool_size=10)?
No, but I tried but no change.
If I try to select more rows:
def testing():
orders = db(db.orders.id > 0).select()
return orders
It takes 80 seconds to return 1608 rows.
If I change the return to return len(troops) it only takes 1,5 seconds.
I have no view defined, just trying out the database.
Kenneth
On Dec 2, 5:13 am, Kenneth Lundström<kenneth.t.lundst...@gmail.com>
wrote:
Hello list,
need some help finding out why my server is so slow.
The server is with a Intel Celeron 2.66 GHz CPU, 4 GB of memory
CentOS 5.5 64-bit, Apache 2.2.3, MySQL 5.0.77, mod_wsgi, Web2py 1.89.5
The server is dedicated to web2py, there is three instances of web2py
running.
I have migrate=False, sessions on disc.
If I try the following code
def testing():
customers = db(db.customer.id> 0).select()
return customers
takes 39 seconds, 5 times in a row, to return 979 rows.
If I put db.customer< 100 it takes 4,5 seconds to return 87 rows.
Is it just me or are this a bit long times?
Kenneth
