Datatable plugin or powerTable does not paginate the data on server, it loads all the records in to memory and the pagination is done in client side DOM.
I guess you dont need to commit() or close connection because web2py does that for you on each request. webfaction is a very nice hosting service, but it crashes too much using web2py when you run with less than 200MB, you can try to customize the apache configuration to run with low number of threads. You can put the data in to a cache or paginate in server side using limitby=(x,y) in your queries. Do you have a local test server (the same config as in webfaction) to run the same application and make a stress test? Can you share your code(where you are doing Bb IO) ? On Fri, Apr 15, 2011 at 12:25 PM, [email protected] < [email protected]> wrote: > Hello, > > As I said before, I believe a system and stayed in webfaction.com. When I > create theapplication there, they already have a script to download the > web2py and prepare itwith Apache. But those weeks while using the system > it gives the following error: > > 502 - Bad Gateway > > > Reported that they were using too much memory, so why the server goes down > . Onlyhas 2 to 4 users accessing the system, and specifically access a list > of records thathave a total of 2000, and is paged using the plugin called > jQuery Javascript DataTable. How do I use the MySQL database, I checked > that was not using commit, andinsert after the queries, insertions and data > edits. Still continued with the error. I askeveryone's help on this, > because I will develop another web application, and I'mtraumatized about > what happened and wanted to use the web2py for this project. What should I > do when I play in production? What best practices should I play in the > project toavoid this memory leaks with Apache and avoid excessive use of > memory in queriesto the database? > _____________________________________________ > *Gilson Filho* > *Web Developer > http://gilsondev.com* > >
