Re: Best practice to minimize DB server performance effect (large query)

2012-05-31 Thread Reindl Harald
DO NOT TOP POST Am 31.05.2012 11:32, schrieb Roland Roland: > On 5/31/12 11:23 AM, Reindl Harald wrote: >> >> Am 31.05.2012 09:13, schrieb Roland RoLaNd: >>> Dear all,I have a task to anonymize data in 82000 >>> record (for the time being)i've tested my script against >>> about 30 of them, and it

Re: Best practice to minimize DB server performance effect (large query)

2012-05-31 Thread Roland Roland
i agree it wouldn't cause trouble, though it might lock mysql as there's a number of other databases running on the same server. so performance is an issue even if it's just a CPU/RAM peak. On 5/31/12 11:23 AM, Reindl Harald wrote: Am 31.05.2012 09:13, schrieb Roland RoLaNd: Dear all,I have

Re: Best practice to minimize DB server performance effect (large query)

2012-05-31 Thread Reindl Harald
Am 31.05.2012 09:13, schrieb Roland RoLaNd: > Dear all,I have a task to anonymize data in 82000 > record (for the time being)i've tested my script against > about 30 of them, and it takes about 2.4 sec for each > query to be executed. provide table structure and query example sounds like a