Problem with Update

Hello everybody We noticed these last days a probleme at the time of the execution of the update commande. The commande make 2 hours and half to be executed, whereas it did not exceed a half front hour. The request updates 50 thousand recordings in only one transaction. When we carried out the some command under dbaccess, we pointed out that the update of the first 10 thousand are done in a second and that for the remainder the request becomes increasingly slow. We put the following questions : - Our current configuration does not allow an update of 50 thousand recordings - It's necessary to commit at the end of each 10 thousand recordings - There are parameters to modify to support an update of 50 thousand recordings in one transaction The situation becomes very critical and I count on your assistance . Best Regards M. AFEILAL

In another instance of dbaccess we check the number of lines which is updated Best Regards M. AFEILAL "Ardila, Henry (EDS Operations Pour : "'mohamed.afe....'" <mohamed.afeilal@meditel.ma> (AdSC))" cc : <henry.ardila-ed Objet : RE: Problem with Update [752] s@eds.com> 18/03/2003 02:25 How are you running this from dbaccess ? Reg, Henry -----Original Message----- From: mohamed.afe.... [mailto:mohamed.afeilal@meditel.ma] Sent: Tuesday, 18 March 2003 11:13 To: ids@iiug.org Subject: Problem with Update [752] Hello everybody We noticed these last days a probleme at the time of the execution of the update commande. The commande make 2 hours and half to be executed, whereas it did not exceed a half front hour. The request updates 50 thousand recordings in only one transaction. When we carried out the some command under dbaccess, we pointed out that the update of the first 10 thousand are done in a second and that for the remainder the request becomes increasingly slow. We put the following questions : - Our current configuration does not allow an update of 50 thousand recordings - It's necessary to commit at the end of each 10 thousand recordings - There are parameters to modify to support an update of 50 thousand recordings in one transaction The situation becomes very critical and I count on your assistance . Best Regards M. AFEILAL