Hello, Don't store sessions in table - it's not MySQL. When you'll issue SELECT count(*) to count them, you'll see delays. Use NoSQL frameworks for this purpose.
Regards, Alexey Kovyazin IBSurgeon > 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 ...) > > [Non-text portions of this message have been removed]
