Unless you show us the prepare of the statement associated with the handle,
and thus its plan as well, there probably isn't anything we can suggest that
you would have control over.

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com


""Sandeep"" <sandeep@...> wrote in message
news:3BFD1DCF.2394.1B16218@localhost...

> Hi
>
> This the log I got from SQLMonitor
>
> SECONDS = 0.010 <------------------------PointA
> ----*/
> /*---
> [ 22/11/2001 15:38:20 ]
> DESCRIBE INPUT
> STMT_HANDLE = 30803004
> PARAMS = [ Version 1 SQLd 1 SQLn 1
> < SQLType: 501 SQLLen: 2 > = <NIL> ]
> ----*/
> /*---
> [ 22/11/2001 15:38:20 ]
> EXECUTE STATEMENT
> TR_HANDLE = 30658808
> STMT_HANDLE = 30803004
> PARAMS = [ Version 1 SQLd 1 SQLn 1
> [OLNK_INV_STATE] = -32768 ]
>
> SECONDS = 20.279<------------------------PointB
>
> I don't understand what is happening on the server for 20 secs
> between PontA and PointB
>
> I have a simple search screen which searches by Unique field. In
> one case the delay between PointA and PointB is less than 1 sec
> and in this case 20 sec. Any idea what could be causing this?
>
> Regards
>
>
> Sandeep
>
> Software Developer
> CFL
> sandeep@...
> http://www.cfl.co.nz