Skip to main content

Does storing large sessions slow down response time and server

Image
By User



I am in the process of creating a Facebook App for my website which includes functionality that requires the users friends list.





Retrieving the friends is no problem, what I am struggling to decide, is how to store them.







  1. Option 1 - Store the users in my MySQL database, I have opted not to go for this as my database will become very heavy, very quickly. In addition, I will need to create a table for each individual Facebook user!





  2. Option 2 - Store the Facebook friends array in a session which is updated every half an hour to ensure new friends are included. Ignore the fact that the session updates every half an hour, is it a bad idea to store, what can be a very large array, within a session?







The website is likely to be receiving high volumes of traffic, and will therefore be storing a lot of these sessions.





Although I am an experienced developer, I am not overly experienced with sessions in these circumstances. I would simply like to know whether or not this is a bad idea?





Just to give you a little info on the typical friends array:





  1. Each array is multidimensional in the format {0[uid:1,name:Jo Bloggs,picture:test.jpg],1...}



  2. A friends list typically ranges from 100 items to 5000 items, although averaging around 700. These are not small!







If this is a bad method for storing the friends, what other options (excluding MySQL) are there?





Do sessions have an effect on memory (RAM) usage?


Labels:

Comments

  1. Tips For AllJanuary 31, 2012 at 2:57 AM

    For your requirements, I highly recommend installing MemCacheD on your server. See: http://memcached.org/ for more information.

    Session is only for the current user logged in, so sharing the information would be hard between sessions. Also when the session goes away, so does the user data.

    For memcached data is stored in key/value pairs.

    So for a key, you could use facebook ID, and for the value, a serialized object of user data.

    ReplyDelete

Post a Comment

Popular posts from this blog

Why is this Javascript much *slower* than its jQuery equivalent?

By User
I have a HTML list of about 500 items and a "filter" box above it. I started by using jQuery to filter the list when I typed a letter (timing code added later): $('#filter').keyup( function() { var jqStart = (new Date).getTime(); var search = $(this).val().toLowerCase(); var $list = $('ul.ablist > li'); $list.each( function() { if ( $(this).text().toLowerCase().indexOf(search) === -1 ) $(this).hide(); else $(this).show(); } ); console.log('Time: ' + ((new Date).getTime() - jqStart)); } ); However, there was a couple of seconds delay after typing each letter (particularly the first letter). So I thought it may be slightly quicker if I used plain Javascript (I read recently that jQuery's each function is particularly slow). Here's my JS equivalent: document.getElementById('filter').addEventListener( 'keyup', function () { var jsStart = (new Date).getTime()...
3 comments
Read more

Is it possible to have IF statement in an Echo statement in PHP

By User
Thanks in advance. I did look at the other questions/answers that were similar and didn't find exactly what I was looking for. I'm trying to do this, am I on the right path? echo " <div id='tabs-".$match."'> <textarea id='".$match."' name='".$match."'>". if ($COLUMN_NAME === $match) { echo $FIELD_WITH_COLUMN_NAME; } else { } ."</textarea> <script type='text/javascript'> CKEDITOR.replace( '".$match."' ); </script> </div>"; I am getting the following error message in the browser: Parse error: syntax error, unexpected T_IF Please let me know if this is the right way to go about nesting an IF statement inside an echo. Thank you.
5 comments
Read more