Forum Replies Created

  • Alan Davey

    Member
    January 23, 2025 at 8:57 pm in reply to: Speed issues between Omnis and Postgres

    Something else to avoid latency and additional network round trips is to use:
    vStatementObj.$execdirect()

    instead of:

    vStatementObj.$prepare()
    vStatementObj.$execute()

    The latter will make two calls to your database with the $prepare in many cases taking just as long as $execute. So by using $execdirect you can cut this time in half.

    Regards,

    Alan