E
Eduardo Aceves Ledezma
Guest
Hi Guys! We're having a problem with a Pacific server when multiple clients do a request, I'll explain myself: We have a query that requires a high demand on the production server because the table we use has millions of records. That query normally takes 3 seconds to complete, but, as soon as you do this query multiple times using different clients, the execution times get multiplied by the number of clients, like 6 seconds when we do it with 2 clients, 9 seconds when we do it with 3, and so on. The architecture of our application is RESTful, and the query doesn't involves any kind of exclusive locks. Any suggestion on this case? Is there any other possibility for tunning for PAS or the RDBMS on this kind of scenarios? Regards!
Continue reading...
Continue reading...