If this is your first visit, check our documentation. To post, register or login.
Forums / Code Collaboration / change bbdd , key in table sessions.

change bbdd , key in table sessions.

Started by jucorant on 13 Aug 2019, 4:41 PM · Views: 1,690

Results 1 to 1 of 1
13 Aug 2019, 4:41 PM
#1
jucorant avatar

jucorant

New Zenner

Join Date:
Oct 2009
Posts:
1
Plugin Contributions:
0

change bbdd , key in table sessions.

All versions.

create key expiry of the sessions table.

In websites with a lot of traffic, speed improves.

CREATE TABLE IF NOT EXISTS sessions (
sesskey varchar(32) NOT NULL DEFAULT '',
expiry int(11) unsigned NOT NULL DEFAULT '0',
value mediumblob NOT NULL
)

ALTER TABLE megahogar2_sessions
ADD PRIMARY KEY (sesskey), ADD KEY expiry (expiry);