Re: slow inserts on NT
Someone mentioned here, that Informix does not support SP4 ... although I have no experience with NT. rick david_dd@my-dejanews.com wrote: > > Hi, > I'm running Informix 7.30.TC7 on NT4 SP4 and I seem to be having a > problem inserting with on table. > I have one table with 4 columns and about 2.5 mil rows. The columns > are > id - integer > hi_res - byte (blob about 50k) > scan_date - date time > img_status - char(1) > Selects are fast and the rest of the app is fast but inserts into this > table are slow. They used to be fast but they are getting slower and > slower. I ran update statistics. Even ran them high and it did not > help. Also the IECC console is slow to connect and the tablespace info > takes a long time to come back (up to 1 hour). Any ideas? > Thanks. > > --== Sent via Deja.com http://www.deja.com/ ==-- > ---Share what you know. Learn what you don't.---
Informix support told me that 7.30.TC7 does run on SP4. But this problem was going on before the upgrade anyway. David In article <7hclpi$cbt$1@news.xmission.com>, RICK_@t-online.de (Juergen Anzer) wrote: > > Someone mentioned here, that Informix does not > support SP4 ... > although I have no experience with NT. > > rick > > david_dd@my-dejanews.com wrote: > > > > Hi, > > I'm running Informix 7.30.TC7 on NT4 SP4 and I seem to be having a > > problem inserting with on table. > > I have one table with 4 columns and about 2.5 mil rows. The columns > > are > > id - integer > > hi_res - byte (blob about 50k) > > scan_date - date time > > img_status - char(1) > > Selects are fast and the rest of the app is fast but inserts into this > > table are slow. They used to be fast but they are getting slower and > > slower. I ran update statistics. Even ran them high and it did not > > help. Also the IECC console is slow to connect and the tablespace info > > takes a long time to come back (up to 1 hour). Any ideas? > > Thanks. > > > > --== Sent via Deja.com http://www.deja.com/ ==-- > > ---Share what you know. Learn what you don't.--- > > --== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.---