- Posts: 77
- Thank you received: 4
Ask the community, share ideas, and connect with other LimeSurvey users!
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
'session' => array ( 'class' => 'application.core.web.DbHttpSession', 'connectionID' => null, 'sessionTableName' => '{{sessions}}', ),
10 seconds? Stick to SSD storage in combination with sessions-files. Wouldn't use Limesurvey without SSD. 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: 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:
Actually : if 'connectionID' => null, : Yii app create a sqlite db in /tmp/runtime/session-1.1.17.dbCode:'session' => array ( 'class' => 'application.core.web.DbHttpSession', 'connectionID' => null, 'sessionTableName' => '{{sessions}}', ),
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.
Big session is here since a lot of year then hard to remove (because a lot of functionality depend from this session).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.
/tmpfs, yes.bruce78 wrote: I'm guessing your talking about using one of ramfs or tmpfs and mounting the directory in fstab?