tunear un insert
hola tengo un insert que me esta demorando demasiado, es posible tunerarlo. El insert es del into insert into tabla(campo1, cmpo2) values (val1, val2)...., me sale que tiene un costo de 64234
El problema puede ser algun trigger que se active al realizar la inserción de datos. Verificalo en el esquema de la base de datos. > To: ids@iiug.org> From: fpaezbecker@hotmail.com> Subject: tunear un insert [13271]> Date: Wed, 3 Sep 2008 15:42:11 -0400> > hola tengo un insert que me esta demorando demasiado, es posible tunerarlo. El > insert es del into insert into tabla(campo1, cmpo2) values (val1, val2)...., > me sale que tiene un costo de 64234 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > _________________________________________________________________ See how Windows connects the people, information, and fun that are part of your life. http://clk.atdmt.com/MRT/go/msnnkwxp1020093175mrt/direct/01/
There's not much you can do to tune a simple INSERT statement. If the row being inserted is very large you can try increasing the size of the communications buffer using the FET_BUF_SIZE environment variable (range 4096 (default) - 32767). If there are many rows that you are inserting, increase FET_BUF_SIZE and use an INSERT or PUT CURSOR, that will make a huge difference. If you have the data on disk, you can try using the HPLOADER. Art 2008/9/3 FERNANDO PAEZ BECKER <fpaezbecker@hotmail.com> > hola tengo un insert que me esta demorando demasiado, es posible tunerarlo. > El > insert es del into insert into tabla(campo1, cmpo2) values (val1, > val2)...., > me sale que tiene un costo de 64234 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.