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
