[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-db
Subject:    Re: [PHP-DB] MySQL vs. Session array
From:       Peter Lind <peter.e.lind () gmail ! com>
Date:       2010-04-07 22:35:30
Message-ID: n2g660eb66f1004071535gd7245174g5552d29fd3f8a234 () mail ! gmail ! com
[Download RAW message or body]

On 8 April 2010 00:13, 3dgtech <systems@3dgtech.com> wrote:
> Quick question. I have an AJAX component that fires a "like" query for each
> "key up" event (since it's a like % query there is no indexing or caching
> possible). While everything works fine, I was contemplaining downloading the
> ~1500 rows into a session var as array, offloading the (seperate) mysql
> server and utilizing the (underutilized) php server. Any thoughts?

You'd be better off storing stuff in memcache than session, would be
my opinion - session is per user, so you wouldn't get much cache reuse
out of it.

-- 
<hype>
WWW: http://plphp.dk / http://plind.dk
LinkedIn: http://www.linkedin.com/in/plind
Flickr: http://www.flickr.com/photos/fake51
BeWelcome: Fake51
Couchsurfing: Fake51
</hype>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[prev in list] [next in list] [prev in thread] [next in thread]