SET a variable in mysql only once -


i using classic asp , mysql (using php wouldn't change point of question).

i need set variable on homepage:

set block_encryption_mode = 'aes-256-cbc' 

i can not set global variable other users using server , may use default block_encryption_mode.

i know can use statement using asp/php on beginning of each webpage, seems using resources; every user execute set statement on every page...

is there way set variable or execute other sql statement @ beggining on each session, onstart event asp has, maybe? or how achieve goal without executing query each user on every page have?

it safe call set on every page executes in orders of microseconds. there literally no overhead calling set on open connection.

unless can apply setting globally, not bother. set block_encryption_mode (together collation , timezone) directly after acquiring database connection handle.


Comments

Popular posts from this blog

service - Android MediaPlayer calls onCompletion before it already finished -

javascript - Training Neural Network to play flappy bird with genetic algorithm - Why can't it learn? -

javascript - Create a stacked percentage column -