plugin_wiki uses he jqGrid plugin and it paginates on server.
On Apr 15, 1:27 pm, Bruno Rocha <[email protected]> wrote: > 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*
