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.

bruce78 wrote:

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.

Sure, I can imagine that... I guess there are no plans to speed up the session design in version 3?

DenisChenu wrote: My /tmp/ and php/temp are already mounted on RAM : then use the default sqlite db : this is very longer for me ...

DenisChenu wrote: Using cache seems a good idea to do some part of session : but
1. all this part must be cut before with User dependant VS not user dependant (we must cache only 'not user dependant')
2. A good obsolete system for caching
More than 2 week of complete work just for Expression Manager StartSurvey, and surely a lot of bug after.

bruce78 wrote: I'm guessing your talking about using one of ramfs or tmpfs and mounting the directory in fstab?