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