Sessions ini settings

php_dev

Hey all,

I am having issues with a script.  It attempts to build an array into a session variable, but I am experiencing a really slow wait time (about 4 seconds to build it)  There are anywhere from 12-40 rows, each containing an array holding 12 fields each.  It shouldn't take 4 seconds to build this array.  I believe (thanks to a forum question) that the problem may be in the file I/O that happens during the session variable creation.  

Does anyone know of any settings that will force PHP to only write to the file once, like maybe on conclusion of the script?  Anything to speed up the time!

Thanks,
php_dev

sneakyimp

It might be helpful to see your code to diagnose the problem. AFAIK, the session variable should only be written to disk at the conclusion of your script.

php_dev

Here is a sample of what I mean. Inside a loop I am building an array of data coming from a database, as I use this information throughout the application. I was also under the impression that PHP would only write to the file at the end of the script, but I am wondering if there is a way to force that, or anything else I could do to speed things up!

while($topics_row=oci_fetch_assoc($topics_query)){
        if($topics_row['IS_UNIVERSAL']==1){
array_push($_SESSION['univ_extra'],array('EXTRA_ID'=>$topics_row['EXTRA_ID'],
                                                                 'EXTRA_ID'=>$topics_row['EXTRA_ID'],
                                                                  'EXTRA_ID'=>$topics_row['EXTRA_ID'],))

Thanks,
php_dev

NogDog

To the best of my knowledge, nothing is written to the session file until the script ends or you explicitly do a session_write_close().

One minor tweak would be to ditch the array_push() function and just directly assign the values to the array. (array_push() is only efficient when using multiple value arguments for a single call: array_push($array, $val1, $val2, ..., $valN).)

$_SESSION['univ_extra'][] = array('EXTRA_ID'=>$topics_row['EXTRA_ID'],
                                                       'EXTRA_ID'=>$topics_row['EXTRA_ID'],
                                                       'EXTRA_ID'=>$topics_row['EXTRA_ID'],));

Hmm...is this déjà vu all over again?

sneakyimp

I'm guessing that you aren't really showing me your code...there's no real reason to assign EXTRA_ID over and over as you have done, so I'm really just guessing.

You might want to try altering your query to make sure that IS_UNIVERSAL==1 first and then try something like this:

$_SESSION['univ_extra'] = oci_fetch_all($topics_query);