Re: Please Help - Performance problem when opening a CURSOR!

> I am running INFORMIX 5.10 on a HP-K220 server with UNIX 10.20. My >application(ESQLC) prepares,declares and opens a cursor into a table. > > The select statement looks like this: > SELECT field_1,field_2,....,field_x FROM table > WHERE field_2 = ? AND field_n = 'xyz' AND field_o = '123' > ORDER BY field_p> > The OPEN statement looks like this: > OPEN cursor_name using $FIELD_2; > >This works fine most of the time, but sometimes the application is held up >waiting on the OPEN CURSOR for as long as 5 minutes. Monitoring it through >glance, the sqlturbo spawned by the process is waiting for IO, even though >this is the only user process running on the system. I can also see that the >disk utilization of the chunk that this table resides on stays at about 95% >to 100%(which does not happen normally). I have used 'tbcheck -pe' to see if >the table had too many extents and found that it always has only 2 extents. >The number of rows in the table is not very different when this happens >compared to when the system functions normally. I have also found out that >dropping the table after unloading the data and doing a dbload to load back >the data corrects the problem. Can anybody help me in figuring out what could >be causing this hangup. Have you run an UPDATE STATISTICS? HTH. Get Your Private, Free Email at http://www.hotmail.com