Have you try node-pool module.? On Dec 27, 2012 11:31 AM, "Andrey" <andrey.sido...@gmail.com> wrote:
> In addition to all previous posts: > > Note that mysql protocol is synchronous (you can't send next query before > receiving result from previous) and all mysql clients queue commands in > some way. Unless you have two separate connections from pool you can safely > do > > mysql.query("one big query"); > mysql.query("second big query").on('end', render); > > - this way render is called only after both queries are finished. > > > On Wednesday, 26 December 2012 04:14:27 UTC+11, Joman Sierra wrote: >> >> I have this scenario: >> >> function one >> { >> Makes a query to a big mysql table >> >> } >> >> Function two >> { >> Makes another query to a big myslq table >> } >> >> res.render(showing results of the queries) >> >> >> The problem is that when render is executed the mysql queries are still >> in progress. What's the best way to be sure that the functions has >> finished before sending the render? >> > -- > Job Board: http://jobs.nodejs.org/ > Posting guidelines: > https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines > You received this message because you are subscribed to the Google > Groups "nodejs" group. > To post to this group, send email to nodejs@googlegroups.com > To unsubscribe from this group, send email to > nodejs+unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/nodejs?hl=en?hl=en > -- Job Board: http://jobs.nodejs.org/ Posting guidelines: https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines You received this message because you are subscribed to the Google Groups "nodejs" group. To post to this group, send email to nodejs@googlegroups.com To unsubscribe from this group, send email to nodejs+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/nodejs?hl=en?hl=en