Bug #66750 Time out error while handling millions of records in MYSql
Submitted: 10 Sep 2012 7:56 Modified: 10 Sep 2012 12:09
Reporter: Priya WBCPriya Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Performance Schema Severity:S5 (Performance)
Version: OS:Windows
Assigned to: CPU Architecture:Any

[10 Sep 2012 7:56] Priya WBCPriya 
Description:
while page loading it refers more than 4 tables and retrieve the records using ASP.NET, at that time, time out error occurs. Each tables contains lakhs of records. How can i resolve this problem?

How to repeat:
Time out error while handling millions of records in MYSql
[10 Sep 2012 12:09] MySQL Verification Team 
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.

A good place to start:
http://dev.mysql.com/doc/refman/5.5/en/optimization.html