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] <javascript:>>: > >> 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] <javascript:>. >> 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.
