I am writing nginx module which uses sqlite to do some read operation. As sqlite read doesn't support non-blocking call(according to my knowledge). What will be best solution to integrate it with nginx. <br>I am accepting near about 200 at the same <span style="color:rgb(0,0,0);font-family:sans-serif;font-size:13px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:19px;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);display:inline!important;float:none"></span>time. One request takes near about 200 ms to process. What method will be the best implementation using nginx:<br>
<br><ol><li>Increasing nginx worker process count to 50-200. So I will having enough worker to accept client request. <br>My concern it that will it increasing connecting time of a user on next request as there will be less chances that same user will be served by same nginx worker process. <br>
</li><li>Doing te read in a thread and using nginx event based api to send response. So I can handle multiple client using only two or one worker process.</li><li>Moving my code to fastcgi and using nginx fastcgi module to communicate with . <br>
<br>What will be the best solution for this implementation ? <br><br> </li></ol>regards<div>Vivek Goel</div><br>