Execute multiple queries on a single connection simultaneously.

  • Eagerly waiting for poster reply

     


    * Noel

  • The reason why I want asynchronous execution is because that way both the queries will get executed on the same connection simultaneously and at the same time hence it will be quicker than executing them sequentially which I believe is the default way of executing multiple queries and might be slower in comparison.


    What I hear I forget, what I see I remember, what I do I understand

  • Can I specify the prefetch clause so that I can regulate (read increase) the number of rows of data that gets copied from the database to the client, as this would mean that I am copying more rows back to the client where by the efficiency could increase.

    Just another school of though (might not be completely in line with what i had posted before).


    What I hear I forget, what I see I remember, what I do I understand

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply