MySQL vs. Session array
| From: | 3dgtech | Date: | Wed, 07 Apr 2010 22:13:37 +0000 |
| Subject: | MySQL vs. Session array | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-47026@lists.php.net to get a copy of this message | ||
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?
PS: maybe even offload it to a JavaScript function??
Thank you,
Eli