[Ilugc] Mysql query issue
- From: lawgon@xxxxxxxxxxxxxxx (Kenneth Gonsalves)
- Date: Fri, 01 Apr 2011 16:12:14 +0530
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/
Other related posts: