Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <h2>APC/Redis/Memcached</h2> <p>If you could you should use <a href="http://scriptperfect.com/2009/09/php-and-apc-tutorial/" rel="nofollow">APC</a>(and/or <a href="http://antirez.com/post/redis-as-LRU-cache.html" rel="nofollow">Redis</a>/<a href="http://memcached.org/" rel="nofollow">Memcached</a>) to cache your data because it is going to be <strong>WAAAAAAAAAAAAAAAAY</strong> faster(everything stays in <strong>MEMORY</strong>). If you want your website to perform good you should have APC(precompiled byte-code in MEMORY) installed anyway.</p> <h2>Cache_Lite</h2> <p>Else you should use the excellent <a href="http://pear.php.net/manual/en/package.caching.cache-lite.php" rel="nofollow">Cache_Lite</a> library to cache your data to a file. <a href="http://pear.php.net/manual/en/package.caching.cache-lite.intro.php" rel="nofollow">The introduction</a> explains perfectly how to use it. If it all possible you should write to <code>/dev/shm/</code> because this maps to <strong>MEMORY</strong> which is going to be way faster then Disc IO.</p> <h2>Splitting Cache</h2> <blockquote> <p>I tried splitting the caching into two files but parts 2 and 3 depend on some php processing of part1 I'm having a hard time...</p> </blockquote> <p>You should have unique pieces(exclusively as large as possible would be best, but sometimes hard to keep track off) and then combine these pieces you need on that page. Each piece should have an unique ID off-course(for retrieval).</p> <pre><code>&lt;?php require_once('Cache/Lite.php'); $options = array( 'cacheDir' =&gt; '/tmp/', 'lifeTime' =&gt; 3600 ); // Create a Cache_Lite object $Cache_Lite = new Cache_Lite($options); if ($data = $Cache_Lite-&gt;get('#{ID for user specific menu}')) { echo($data); } else { $data = 'Data of the block 1-1'; $Cache_Lite-&gt;save($data); } echo('&lt;br&gt;&lt;br&gt;Non cached line !&lt;br&gt;&lt;br&gt;'); if ($data = $Cache_Lite-&gt;get('#{user specific info}')) { echo($data); } else { $data = 'Data of the block 2'; $Cache_Lite-&gt;save($data); } ?&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POconfusing file caching scenario
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USAlfred
    1. USAlfred
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POconfusing file caching scenario
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI think the cache_lite solution (to split in two parts) suits my needs best. My only concern is that if I do that now, will I be able to easily switch to memcached in the future? Is there a sort of trigger in the cache_lite package where I could say "$memory = true" which would ignore the "cacheDir" and switch saving/loading everything to/from memory? Or would I need to make some code changes again and store the two different blocks of data using the memcached functions? Thanks so much.
      singulars
      1. PO
      1. USKentor
    2. COYou should write an wrapper for that. http://www.scribd.com/doc/4069180/Caching-Performance-Lessons-from-Facebook => Look at the cache_get function() allthough you should make it work for APC, memcached and Cache_lite
      singulars
      1. PO
      1. USAlfred
    3. COwow, that is a whole other level of caching.. apc/memcached/cache_lite are all for different purposes? If I understand correctly, cache_lite is to cache page content (html), memcached is for db query, APC is to cache PHP code? To maximize performance, all 3+ should be used as much as possible? First we try to get the cache from global vars, then we could try the saved html, if the file cache is expired then APC would kick in along with memcached and then create a new html file with Cache_Lite right?Am I missing something? it's a bit confusing. Looks like FB does not use hd (cache_lite).thanks!
      singulars
      1. PO
      1. USKentor
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload