Hello, I would like to know if someone has any experience to report here about separating web and database server into distinct server (2 linux box for example).
I making some test actually and found no great improvement to do so... I access the remote database server through ssh port fowarding, so it may be the reason why I have no speed improvement. But I read that if web app is making a lot of db request (1000+) it may be a bad idea to split web server and database server ( http://www.mysqlperformanceblog.com/2006/10/16/should-mysql-and-web-server-share-the-same-box/). In web2py "represent=lambda..." trigger a lot of db request, so I wonder if web2py represent could be responsible of the no speed improvement. I use profiler and the difference between local and remote database is pretty small (.5 sec longer with remote db). I will try to profile remote database with no ssh to see if I get speed improvement and get back here. Thanks Richard PS.: I try to use "performance" as a tag, but I can't add new tag, but I think that having a "performance" tag or "speed" tag could be great... -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
