Talking to myself about sessions [Solved]
It was a symfony thing.
For anyone else's future reference, if you are integrating with some big
monolith of an app and you find that your sessions are "disconnected"
when going from the big app to your little script... check out
session_name().
K bye!
.
Relevant Pages
- Re: List of bad practices
... index on app, starttime, but probably more realistic distribution of values. ... There are too few distinct starttime values. ... > This doesn't really affect the cursor based solution but masively ... FROM Sessions AS S1) AS C ...
(microsoft.public.sqlserver.programming) - Re: List of bad practices
... the original assumption still stands, i.e., the cursor based solution has ... Suppose we're tracking a month worth of sessions data, with 10 applications, ... a covering non-clustered index placed on (app, starttime, endtime). ...
(microsoft.public.sqlserver.programming) - Re: List of bad practices
... An index on app, starttime of course seems like a natural choice here. ... FROM Sessions, Nums ... BG, SQL Server MVP ...
(microsoft.public.sqlserver.programming) - Re: List of bad practices
... >>>> SELECT app, MAXAS mx ... FROM Sessions AS S1) AS C ... >>>> I haven't found a better performing pure set-based solution but I'd ... >>>> cursor outperforms a pure set-based query. ...
(microsoft.public.sqlserver.programming) - Re: List of bad practices
... CREATE TABLE Sessions ... -- Calculate the maximum number of concurrent sessions for each ... Here's one pure set-based solution: ... SELECT app, MAXAS mx ...
(microsoft.public.sqlserver.programming) |
|
