> I have database having 1 Lakh URLS and its content . > I was trying to execute the following query and after 4 hours I got an > error > too > I am pasting the query and error below. Is there anything wrong with the > query > > select count(*) from `WCM-LN`.`reviews_index` where url in(Select link from > urls) > Error Code: 2013. Lost connection to MySQL server during query > > Does this query works for lesser no of Records?
Please avoid using subquery, it will take lot of your CPU and MEM hence leads to connection loss. Use joins instead, or try temporary table( My Recommendation better than join). Index the table for better performance. -- regards Rajesh Kumar R.K _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
