<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <tt>Hi Diptesh,<br>
      <br>
      The avp_db_query, as being a generic way to run raw queries, has
      no support for prepared statements. <br>
      <br>
      Regards,<br>
    </tt>
    <pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
  OpenSIPS Founder and Developer
  <a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a>
</pre>
    <div class="moz-cite-prefix">On 09/29/2017 01:23 PM, Dipteshkumar
      Patel wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAD4_Da1Lx30zi8p-3AhAA2B+HLJaprf4DqawOMHs47RKXM7j7Q@mail.gmail.com">
      <div dir="ltr">Dear Sir, 
        <div><br>
        </div>
        <div><br>
        </div>
        <div>I am using opensips 2.3.1 with multiple queries(using
          avp_db_query) in opensips configuration and i want to optimise
          it, and yes i also use async for that but i need to more
          optimisation.</div>
        <div><br>
        </div>
        <div>how can we use prepared statement in opensips script ?</div>
      </div>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <br>
      <pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
    </blockquote>
    <br>
  </body>
</html>