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 -~----------~----~----~----~------~----~------~--~---
