bruce78 wrote:

DenisChenu wrote: Not currently. And remind : we still use $_SESSIOn : it's one of the reason the first pacge can take a long long long time to call.

Interesting... btw, do you think disk sessions are faster/more reliable than db sessions, all things being equal?

DenisChenu wrote: => Maybe alternative soluton is to use another DB for session, for example a SQLite db (saved in RAM/SSD)

bruce78 wrote:

DenisChenu wrote: => Maybe alternative soluton is to use another DB for session, for example a SQLite db (saved in RAM/SSD)

That's a neat idea... do you think something like that might reduce my first page load time from 10 seconds to something less?

DenisChenu wrote: But think the best solution is to save session in RAM only or SSD. Maybe in a SQLite DB on RAM is the better way.
Denis

'class' => 'application.core.web.DbHttpSession',

'db_sqlite' => array(

Property "DbHttpSession.file" is not defined.

//'class' => 'application.core.web.DbHttpSession',

Object configuration must be an array containing a "class" element.

return array(
  'components' => array(
    'db' => array(
      'connectionString' => 'mysql:host=localhost;port=3306;dbname=dbname;',
      'emulatePrepare' => true,
      'username' => 'user',
      'password' => 'pass',
      'charset' => 'utf8mb4',
      'tablePrefix' => 'lime_',
    ),
 
    // Uncomment the following line if you need table-based sessions
    'session' => array (
    'class' => 'application.core.web.DbHttpSession',
    'connectionID' => 'db_sqlite',
    'sessionTableName' => '{{sessions}}',
    ),
 
 
    'db_sqlite' => array(
      'file' => '/home/test.db',
      'connectionString' => 'sqlite:/home/test.db',
    //  'class' => 'application.core.web.DbHttpSession',
        'emulatePrepare' => true,
      'username' => '',
      'password' => '',
     // 'charset' => 'utf8mb4',
     //  'tablePrefix' => 'lime_',
    ),

DenisChenu wrote: github.com/LimeSurvey/LimeSurvey/blob/ma...bHttpSession.php#L20
Did you try a var dump/die here ? To see if it's the good session ?

DenisChenu wrote: I don't see 'file' => '/home/test.db', in Yii doc about www.yiiframework.com/doc/api/1.1/CDbConnection : what did you add it ? You already have it in connectionString

bruce78 wrote: That's a neat idea... do you think something like that might reduce my first page load time from 10 seconds to something less?

DenisChenu wrote:

Code:

'session' => array (
      'class' => 'application.core.web.DbHttpSession',
      'connectionID' => null,
      'sessionTableName' => '{{sessions}}',
    ),

Actually : if 'connectionID' => null, : Yii app create a sqlite db in /tmp/runtime/session-1.1.17.db

jelo wrote: 10 seconds? Stick to SSD storage in combination with sessions-files. Wouldn't use Limesurvey without SSD.

jelo wrote: Till LimeSurvey is mostly use in small surveys with not many concurrent probands the session misdesign will be last for a long time.