Please, if you succeed in this (and I am sure you will) send us some instructions on how to reproduce it.
On Feb 25, 5:39 am, Kirby Turner <ki...@thecave.com> wrote: > Thanks for the responses Paul and Massimo. > > Sounds like my best next step is to setup a web2py app under IIS with > MSSQL and see what happens before making the final sell to the > customer. I'm confident that if it works, performance is good, and > the setup isn't too difficult I can develop the application in less > time using web2py. Note, I will not have access to the production > server so the setup must be performed by the customer's IT stafff, > which is why I need to make sure it is not difficult, i.e., their > staff can handle it. > > Regarding isapi-wsgi, version 0.2 is single threaded. Version 0.3, > which was recently released, has been modified to overcome the > limitation. From the project's home page: > > "Current status: The isapi_wsgi handler has been modified to overcome > the limitations of the single threaded version of the handler. The new > version provides two handlers: > > * ISAPISimpleHandler - a new handler instance is created per > request > * ISAPIThreadPoolHandler - requests use the thread pool > > Also the isapi_wsgi virtual directory can be accessed via it's root > url. " > > http://code.google.com/p/isapi-wsgi/ > > Sounds promising. > > Thanks again folks! > > -KIRBY > > On Feb 25, 2009, at 12:19 AM, mdipierro wrote: > > > > > According to this > > > http://code.google.com/p/isapi-wsgi/wiki/ISAPISimpleHandlerDocs > > > the iis-wsgi adapter is single threaded. If this means what I think it > > means I would not use it. > > > You can, instead use fastCGI which is provided by Microsoft > > > http://www.iis.net/downloads/default.aspx?tabid=34&g=6&i=1521 > > > web2py includes an adaptor and it is documented in AlterEgo > > > MSSQL is the least tested database back-end and the weirdest of them > > all. It does not support pagination. we made it work in web2py with a > > trick but it is still slower and more inefficient than any other > > database backend. This will eventually be improved. Mind that this is > > not a web2py issue. mssql does not support pagination even if you use > > ASP.NET. > > > Massimo > > > On Feb 24, 9:42 pm, Paul Eden <benchl...@gmail.com> wrote: > >> I don't have any production experience yet with web2py under IIS > >> but I > >> do know that it hypothetically runs because the cherrypy webserver > >> that web2py runs on is wsgi compatible and there is a wsgi adapter > >> for > >> IIS (http://code.google.com/p/isapi-wsgi/). > > >> I have used MSSQL 2005 with python using the pymssql module and with > >> pyodbc both with great results. Pymssql is easier to setup, but uses > >> a deprecated MS C library for MSSQL. > > >> Paul > > >> On Tue, Feb 24, 2009 at 8:26 PM, Kirby Turner <ki...@thecave.com> > >> wrote: > > >>> Hi All, > > >>> There is a possibility I can convince a customer of mind to switch > >>> from ASP.NET MVC to web2py. The catch? It must run under IIS 6 > >>> with > >>> SQL Server 2005. Are there others hosting production web2py apps > >>> under IIS 6 with MSSQL 2005? If so, how was the setup experience? > >>> Difficult, easy? Any unexpected gotcha? > > >>> I searched the mail group and read the other IIS related threads > >>> so my > >>> gut tells me there are not a lot of people using web2py with IIS. > >>> But > >>> maybe I'm wrong. > > >>> Thanks, > >>> -KIRBY > > >> -- > >> Best Regards, > > >> Paul Eden > > >> "...and a little looking out for the other guy too." > >> - Mr. Smith --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" 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 -~----------~----~----~----~------~----~------~--~---
