We have articles about this on web2pyslices.com... Three to be exact. -Thadeus
On Mon, Nov 23, 2009 at 3:45 PM, waTR <r...@devshell.org> wrote: > > Someone needs to do a wiki entry for HIGH PERFORMANCE web2py setup. > > I.e. Apache + WSGI + Postgre/MySQL + Query Cache code + Page Cache > code. > A simple program that could be made for this is an app for allowing > students to register for classes. > Requirements: > Super user can: add classes, change classes (time, section, prof, > etc.), view classes, lock classes (i.e. no additional registrations > allowed), set maximum # students per class (after which additional > students added to waitlist--when some registered student drops, FIFO > method for registering students on waitlist). > Student user can: add classes to time-table, check for pre-requisites, > check for conflicts in schedule, view schedule, join waitlist. > > I'm already writing an app, but would totally make this as it is > EXTREMELY useful for schools. Lots of schools have problems with their > registration system being too slow. This includes private lesson and > adult education programs...this is also especially useful with OBAMA's > announcement today about more funding for schools ;) > > > > On Nov 23, 11:35 am, mdipierro <mdipie...@cs.depaul.edu> wrote: > > What is current setup? Windows binary? Do you know linux? > > > > On Nov 23, 12:36 pm, harshit agrawal <harsh.agrawal2...@gmail.com> > > wrote: > > > > > This is a fact. > > > > > Sir I am almost done with all the queries in my project using the > > > default sqlite and now I want to put the portal on apache server. How > > > can we do this? > > > > > On Nov 23, 12:47 pm, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > > > > On Nov 23, 11:36 am, harshit agrawal <harsh.agrawal2...@gmail.com> > > > > wrote: > > > > > > > But sir my portal will start at a specific time and around 200-250 > > > > > users will login at the same time then the system may hang. > > > > > > Is this an assumption or a fact? > > > > > > > Also there is a file named options_std.py, in this file what does > > > > > 'no_of_threads' means.... > > > > > > that is the number of concurrent threads with wsgiserver. It should > > > > not be relevant in a production environment. > > > > > > In a production environment you should use apache2+mod_wsgi and let > > > > Apache deal with concurrency and serving static files. You should > also > > > > use postgresql (or other database) not the default sqlite. sqlite > > > > always locks the entire database on every request. > > > > > > You can read more on this in chapter 11 of the book and the source of > > > > this script:http://www.web2pyslices.com/main/slices/take_slice/29 > > > > > > Massimo > > > > > > > reply as soon as possible > > > > > > > Thank You > > > > > Harshit > > > > > > > On Nov 23, 10:15 am, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > > > > > > It really depends on many issues. 200 users are not going to make > 1 > > > > > > request/second but more like 1 request every ten seconds each or > less. > > > > > > That means you need to handle 20 requests/seconds. > > > > > > > > On my laptop an average dynamic page takes ~20ms, and that means > 50 > > > > > > requests/second. This means I can handle 200 current users on my > > > > > > laptop. > > > > > > > > The bottleneck is always database access. It really depends on > what > > > > > > those users do with the database. > > > > > > > > Massimo > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
