Hi Juilee, You can override the default connection timeout http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html This however should be a temporary fix/alternative. Do consider sharding on a mysql cluster ( http://www.mysql.com/products/cluster/scalability.html)
Thanks, Chris On Wednesday, August 14, 2013 2:28:03 AM UTC+5:30, Juilee Chitre wrote: > > Hello, > I am referring to this post on stackoverflow. > http://stackoverflow.com/questions/14406488/node-js-mysql-query-timeout > > I am using node for server-side scripting and my web application is > connected to a MySQL database. The database has tables having around 60 > million rows. I have the need to query the database and retrieve the > response and display on my web-page. But, since the database takes around a > few minutes to process a query, node js renders the page before the data is > retrieved. > > Is there any way to set up timeout for a mysql query in node js? > > Thank you. > > Regards, > Juilee > -- -- 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nodejs?hl=en?hl=en --- You received this message because you are subscribed to the Google Groups "nodejs" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
