web2py managing capacity ?

[karthikeyan p]

hello ,

i am new to web2py , i found its a great .

i have planned to make my website with it .

i want to know sociability of web2py !

how to use it with postgresql ? 

[黄祥]

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

[Carlos Costa]

sociability?

--
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+un...@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

[karthikeyan p]

Thanks for reply ; i will try this !

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+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/CAGsD4Nw626C_QyRFDH0wz1bJ52WROSubFequnb4-p1h1WB5BOA%40mail.gmail.com.

[karthikeyan p]

sorry ,

Carlos Costa  , i typed wrongly !   its scalability , i want to know web2py apps scalability !

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+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/CAGsD4Nw626C_QyRFDH0wz1bJ52WROSubFequnb4-p1h1WB5BOA%40mail.gmail.com.

[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 <yamand...@gmail.com> wrote:

sociability?

Em sex, 24 de mai de 2019 às 05:18, 黄祥 <steve.va...@gmail.com> 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.

[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.