Hello,

I have a table that i use to store session

Table Session
ID: VARCHAR(16); /* GUID ID */
Expiry_date: Timestamp;
Data: Varchar(1000);

i use the table like this only :

Insert into Session(ID,Expiry_date,Data)
VALUES (CHAR_TO_UUID(NewGUID), NOW + 15minutes,...)

Update Session Set
data=...
Expiry_date= NOW + 15minutes
where
id=... and
Date_expired < 'NOW'

Select ... from SESSION where
ID=... and Expiry_date > 'NOW'

THat ok,

now the probleme is that i have another thread that one time a day delete all the expired node

Delete From SESSION where Expiry_date < NOW - 3 days

i use isc_tpb_write + isc_tpb_read_committed + isc_tpb_no_rec_version + isc_tpb_wait for this second thread (but normally as i delete the rec that expire 3 days ago they must not be any probleme of deadlock)

but the probleme is that this SQL make hours (days?) to return :(
if i replace the isc_tpb_wait by isc_tpb_nowait then i have often some deadlock (why ?? still not understand ...)