Then, in my opinion the first thing to do would be to move to MySQL or Postgresql and I'd put the database on a different server. For me, I'd go with MySQL but others here on the list may argue that postgres is the better option. I don't feel that fetching the 'full' html is the issue. It has been stated time and time again in this group that web2py is rarely the bottleneck in performance. Typically look at the database first.
-Jim On Tuesday, April 4, 2017 at 7:56:08 AM UTC-5, Áureo Dias Neto wrote: > > Right, i'm using sqlite actualy > > 2017-04-04 9:51 GMT-03:00 Jim S <[email protected] <javascript:>>: > >> 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] <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.
