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