Re: [web2py] Re: web2py managing capacity ?

2019-06-07 Thread Dave S 


On Tuesday, June 4, 2019 at 12:00:09 PM UTC-7, Dave S wrote:
>
>
>
> On Tuesday, June 4, 2019 at 9:12:24 AM UTC-7, karthikeyan p wrote:
>>
>> sorry , 
>> Carlos Costa 
>> , i typed wrongly !
>>   its scalability , i want to know web2py apps scalability !
>>
>
> Well, that depends on your application (how much work your app does on a 
> request), your front end, and your database.
>
> With nginx + uwsgi as a front end on an AWS instance, I can sustain 2 
> requests per second with load usually staying below 0.10 (0.8-0.09 typical).
> SQLite3 was working for me until I got up around 500,000 entries, and 
> "database locked" conflicts crept up.  I switched to postgres and the 
> system almost fell over ... until I created an index.
>
>
For completeness, this is a t2.micro instance.
 

>
> Massimo has customer systems with a bigger load, and so do several 
> others.  I think most production systems are on a Linux host, but there are 
> a lot of IIS systems, as well.  The Scheduler code works well in both 
> enviornments.  Rocket on either Linux or Windows works fine for 
> development, but I've seen some issues with large files from Windows 
> clients (end-of-post not recognized; data stored only after timeout).
>
> Early tests of web3py are, Massimo says, "way faster".
>
> /dps
>
>
>
>
>
>> On Fri, May 24, 2019 at 8:22 PM Carlos Costa  wrote:
>>
>>> sociability?
>>>
>>> Em sex, 24 de mai de 2019 às 05:18, 黄祥  escreveu:
>>>
 how to use it with postgresql ? 
>

 pls set the uri connection first
 *e.g. private/appconfig.ini*
 uri = postgres://postgres:password@localhost/database_name

 *ref:*

 http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Connection-strings-the-uri-parameter-
  

 best regards,
 stifan

 -- 
 Resources:
 - http://web2py.com
 - http://web2py.com/book (Documentation)
 - http://github.com/web2py/web2py (Source code)
 - https://code.google.com/p/web2py/issues/list (Report Issues)
 --- 
 You received this message because you are subscribed to the Google 
 Groups "web2py-users" group.
 To unsubscribe from this group and stop receiving emails from it, send 
 an email to web...@googlegroups.com.
 To view this discussion on the web visit 
 https://groups.google.com/d/msgid/web2py/9a708b39-7b1e-4c77-a4b3-49b7bdac9215%40googlegroups.com
  
 
 .
 For more options, visit https://groups.google.com/d/optout.

>>>
>>>
>>> -- 
>>> At.
>>>
>>> Carlos J. Costa
>>> --
>>> Cientista da Computação - Esp. Gestão em Telecom
>>>
>>> -- 
>>> Resources:
>>> - http://web2py.com
>>> - http://web2py.com/book (Documentation)
>>> - http://github.com/web2py/web2py (Source code)
>>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>>> --- 
>>> You received this message because you are subscribed to a topic in the 
>>> Google Groups "web2py-users" group.
>>> To unsubscribe from this topic, visit 
>>> https://groups.google.com/d/topic/web2py/eZogykbJDOY/unsubscribe.
>>> To unsubscribe from this group and all its topics, send an email to 
>>> web...@googlegroups.com.
>>> To view this discussion on the web visit 
>>> https://groups.google.com/d/msgid/web2py/CAGsD4Nw626C_QyRFDH0wz1bJ52WROSubFequnb4-p1h1WB5BOA%40mail.gmail.com
>>>  
>>> 
>>> .
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/453f0a48-758b-49af-a81b-d5e32c86a342%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py managing capacity ?

2019-06-04 Thread Dave S 


On Tuesday, June 4, 2019 at 9:12:24 AM UTC-7, karthikeyan p wrote:
>
> sorry , 
> Carlos Costa 
> , i typed wrongly !
>   its scalability , i want to know web2py apps scalability !
>

Well, that depends on your application (how much work your app does on a 
request), your front end, and your database.

With nginx + uwsgi as a front end on an AWS instance, I can sustain 2 
requests per second with load usually staying below 0.10 (0.8-0.09 typical).
SQLite3 was working for me until I got up around 500,000 entries, and 
"database locked" conflicts crept up.  I switched to postgres and the 
system almost fell over ... until I created an index.


Massimo has customer systems with a bigger load, and so do several others.  
I think most production systems are on a Linux host, but there are a lot of 
IIS systems, as well.  The Scheduler code works well in both enviornments.  
Rocket on either Linux or Windows works fine for development, but I've seen 
some issues with large files from Windows clients (end-of-post not 
recognized; data stored only after timeout).

Early tests of web3py are, Massimo says, "way faster".

/dps





> On Fri, May 24, 2019 at 8:22 PM Carlos Costa  > wrote:
>
>> sociability?
>>
>> Em sex, 24 de mai de 2019 às 05:18, 黄祥 > > escreveu:
>>
>>> how to use it with postgresql ? 

>>>
>>> pls set the uri connection first
>>> *e.g. private/appconfig.ini*
>>> uri = postgres://postgres:password@localhost/database_name
>>>
>>> *ref:*
>>>
>>> http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Connection-strings-the-uri-parameter-
>>>  
>>>
>>> best regards,
>>> stifan
>>>
>>> -- 
>>> Resources:
>>> - http://web2py.com
>>> - http://web2py.com/book (Documentation)
>>> - http://github.com/web2py/web2py (Source code)
>>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>>> --- 
>>> You received this message because you are subscribed to the Google 
>>> Groups "web2py-users" group.
>>> To unsubscribe from this group and stop receiving emails from it, send 
>>> an email to web...@googlegroups.com .
>>> To view this discussion on the web visit 
>>> https://groups.google.com/d/msgid/web2py/9a708b39-7b1e-4c77-a4b3-49b7bdac9215%40googlegroups.com
>>>  
>>> 
>>> .
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>
>> -- 
>> At.
>>
>> Carlos J. Costa
>> --
>> Cientista da Computação - Esp. Gestão em Telecom
>>
>> -- 
>> Resources:
>> - http://web2py.com
>> - http://web2py.com/book (Documentation)
>> - http://github.com/web2py/web2py (Source code)
>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>> --- 
>> You received this message because you are subscribed to a topic in the 
>> Google Groups "web2py-users" group.
>> To unsubscribe from this topic, visit 
>> https://groups.google.com/d/topic/web2py/eZogykbJDOY/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to 
>> web...@googlegroups.com .
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/web2py/CAGsD4Nw626C_QyRFDH0wz1bJ52WROSubFequnb4-p1h1WB5BOA%40mail.gmail.com
>>  
>> 
>> .
>> For more options, visit https://groups.google.com/d/optout.
>>
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/458cd0e6-493f-463d-a6d7-afbbb54a43dd%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py managing capacity ?

2019-06-04 Thread karthikeyan p 
sorry ,
Carlos Costa
, i typed wrongly !
  its scalability , i want to know web2py apps scalability !

On Fri, May 24, 2019 at 8:22 PM Carlos Costa 
wrote:

> sociability?
>
> Em sex, 24 de mai de 2019 às 05:18, 黄祥 
> escreveu:
>
>> how to use it with postgresql ?
>>>
>>
>> pls set the uri connection first
>> *e.g. private/appconfig.ini*
>> uri = postgres://postgres:password@localhost/database_name
>>
>> *ref:*
>>
>> http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Connection-strings-the-uri-parameter-
>>
>>
>> best regards,
>> stifan
>>
>> --
>> Resources:
>> - http://web2py.com
>> - http://web2py.com/book (Documentation)
>> - http://github.com/web2py/web2py (Source code)
>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "web2py-users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to web2py+unsubscr...@googlegroups.com.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/web2py/9a708b39-7b1e-4c77-a4b3-49b7bdac9215%40googlegroups.com
>> 
>> .
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
> --
> At.
>
> Carlos J. Costa
> --
> Cientista da Computação - Esp. Gestão em Telecom
>
> --
> Resources:
> - http://web2py.com
> - http://web2py.com/book (Documentation)
> - http://github.com/web2py/web2py (Source code)
> - https://code.google.com/p/web2py/issues/list (Report Issues)
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "web2py-users" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/web2py/eZogykbJDOY/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> web2py+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/CAGsD4Nw626C_QyRFDH0wz1bJ52WROSubFequnb4-p1h1WB5BOA%40mail.gmail.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CADrkE%3DHniCoQ19ieCu6ehx0zACdHH6vHVKu1dX0J2%2Bb1oNo8AA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py managing capacity ?

2019-05-24 Thread karthikeyan p 
Thanks for reply ; i will try this !

On Fri, 24 May 2019 at 8:22 PM, Carlos Costa 
wrote:

> sociability?
>
> Em sex, 24 de mai de 2019 às 05:18, 黄祥 
> escreveu:
>
>> how to use it with postgresql ?
>>>
>>
>> pls set the uri connection first
>> *e.g. private/appconfig.ini*
>> uri = postgres://postgres:password@localhost/database_name
>>
>> *ref:*
>>
>> http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Connection-strings-the-uri-parameter-
>>
>>
>> best regards,
>> stifan
>>
>> --
>> Resources:
>> - http://web2py.com
>> - http://web2py.com/book (Documentation)
>> - http://github.com/web2py/web2py (Source code)
>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "web2py-users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to web2py+unsubscr...@googlegroups.com.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/web2py/9a708b39-7b1e-4c77-a4b3-49b7bdac9215%40googlegroups.com
>> 
>> .
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
> --
> At.
>
> Carlos J. Costa
> --
> Cientista da Computação - Esp. Gestão em Telecom
>
> --
> Resources:
> - http://web2py.com
> - http://web2py.com/book (Documentation)
> - http://github.com/web2py/web2py (Source code)
> - https://code.google.com/p/web2py/issues/list (Report Issues)
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "web2py-users" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/web2py/eZogykbJDOY/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> web2py+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/CAGsD4Nw626C_QyRFDH0wz1bJ52WROSubFequnb4-p1h1WB5BOA%40mail.gmail.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CADrkE%3DEhWZnb04zH%3Do55-AOsX8tFnTBofji4-kQP6%3D1Xsi48Rw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py managing capacity ?

2019-05-24 Thread Carlos Costa 
sociability?

Em sex, 24 de mai de 2019 às 05:18, 黄祥 
escreveu:

> how to use it with postgresql ?
>>
>
> pls set the uri connection first
> *e.g. private/appconfig.ini*
> uri = postgres://postgres:password@localhost/database_name
>
> *ref:*
>
> http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Connection-strings-the-uri-parameter-
>
>
> best regards,
> stifan
>
> --
> Resources:
> - http://web2py.com
> - http://web2py.com/book (Documentation)
> - http://github.com/web2py/web2py (Source code)
> - https://code.google.com/p/web2py/issues/list (Report Issues)
> ---
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/9a708b39-7b1e-4c77-a4b3-49b7bdac9215%40googlegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>


-- 
At.

Carlos J. Costa
--
Cientista da Computação - Esp. Gestão em Telecom

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CAGsD4Nw626C_QyRFDH0wz1bJ52WROSubFequnb4-p1h1WB5BOA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: web2py managing capacity ?

2019-05-24 Thread 黄祥 

>
> how to use it with postgresql ? 
>

pls set the uri connection first
*e.g. private/appconfig.ini*
uri = postgres://postgres:password@localhost/database_name

*ref:*
http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Connection-strings-the-uri-parameter-
 

best regards,
stifan

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/9a708b39-7b1e-4c77-a4b3-49b7bdac9215%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.