Right, i'm using sqlite actualy 2017-04-04 9:51 GMT-03:00 Jim S <[email protected]>:
> I personally am a MySQL guy, but for high volume databases I think some > may say postgres would be a better option. > > Regarding middleware, I was referring to uwsgi. > > So, which database are you currently using? > > -Jim > > > On Tuesday, April 4, 2017 at 7:40:33 AM UTC-5, Áureo Dias Neto wrote: >> >> I use nginx with uwsgi as a server in the centos .. the database, I was >> wondering if you have experiences on performance between sqlite and mysql >> or postgresql? >> >> -middleware in case, would it be in REST applications? >> >> thanks >> >> 2017-04-04 9:33 GMT-03:00 Jim S <[email protected]>: >> >>> It might help if you described your production environment a bit. What >>> servers/middleware? What database? >>> >>> -Jim >>> >>> >>> On Tuesday, April 4, 2017 at 7:10:53 AM UTC-5, Áureo Dias Neto wrote: >>>> >>>> Friends, assuming a hypothetical application .. >>>> >>>> If I have a large multiuser and monolithic application .. with the >>>> growing of it (more clients, more concurrent accesses) .. I have some >>>> doubts .. >>>> >>>> For example search and report screens: >>>> >>>> 1) If I ask to fetch records and fill a table with 200 records, this >>>> query takes too much time and enough server resources .. >>>> >>>> How to optimize this type of question? Make the application scalable >>>> and also support several accesses, queries, ultimately users using it .. >>>> Is it feasible to consider a REST application? Are there optimizations >>>> to be made when moving from the development environment to the production >>>> environment when using web2py? I wanted your opinions on these issues, >>>> because over time and growing from the database, returning 'full' html (we >>>> use this term for non-REST or monolithic applications) becomes cumbersome >>>> and slow .. >>>> >>>> >>>> Hugs and keep loving python! <3 >>>> >>> -- >>> 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 [email protected]. >>> 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 [email protected]. > 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
