On Fri, 2011-04-01 at 16:04 +0530, JAGANADH G wrote: > The above dedupe query is working.I checked it in a tabel which > contains > 10,000 records.All the duplicate hash values are removed. > But my problem is while trying the same query in large table > (20,000,00),it > takes too long. > On a test run the query runs 24 hours and not completed
this is a one-off query to clean the database. There is no point trying to optimise it (IMHO). I had to do the same with a pg database, with a few thousand records and it took an hour or two (old machine). -- regards KG http://lawgon.livejournal.com Coimbatore LUG rox http://ilugcbe.techstud.org/ _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
