List:General Discussion« Previous MessageNext Message »
From:Martin Rytz Date:August 10 2004 1:51pm
Subject:Problem with Slow Update Query
View as plain text  
Hi all
 
I have a problem with slow update queries like these (5 examples):
 
update url_cat set domain = '01net' where left( domain, instr( domain, '.' )
-1 ) = '01net';
update url_cat set domain = '1-meta' where left( domain, instr( domain, '.'
) -1 ) = '1-meta';
update url_cat set domain = '105' where left( domain, instr( domain, '.' )
-1 ) = '105';
update url_cat set domain = '123love' where left( domain, instr( domain, '.'
) -1 ) = '123love'; 
update url_cat set domain = 'google' where left( domain, instr( domain, '.'
) -1 ) = 'google'; 
 
before the update, the field domain contains 'google.com' or 'google.de' or
'google.ch' and after the update it contains only 'google'.
 
i have to make thousends of this updates an it takes a long time. the table
'url_cat' contains about 100'000 entries! an index would help, but mysql
does not use any static index. the index should contain the
where-condition... but this is not possible, because the lenght of the
condition differs?! 
 
does anybody have another idea?
 
thank you in advance.
martin   

Thread
Problem with Slow Update QueryMartin Rytz10 Aug
  • Re: Problem with Slow Update QuerySGreen10 Aug
  • Re: Problem with Slow Update QueryMichael Stassen10 Aug