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
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
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
(+27) (0)82 747 6127
Email: vince.dug...@virginactive.co.za
Live happily ever active
firebird-support@yahoogroups.com wrote on 2012/02/28 05:03:59 PM:
[image removed]
[firebird-support] Update take hours to delete records :(
nathanelrick
to:
firebird-support
2012/02/28 05:04 PM