StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Everyone has given a wide range of opinions but I don't think anyone has really hit the nail on the head.</p> <p>When it comes down to storing data, the amount of data, the rate it is to be accessed, and several other factors all determine what's the best storage platform.</p> <p>Some people have suggested using memcached. Now although this is a valid answer (you <strong>can</strong> use it), I don't think that this is a good idea, solely based on the fact that memcached stores data within your server's memory.</p> <p>Your memory is not for data storage, it's for use of the actual applications, operating system, shared libraries, etc.</p> <p>Storing data within the memory can cause a lot of issues with other applications currently running. If you store too much data in your RAM your applications would not be able to complete operations assigned to them.</p> <p>Although this is faster then a disk based storage platform such as MySQL, it's not as reliable.</p> <p>I would personally use MySQL as your storage engine server-side. This would reduce the amount of problems you would come across and also makes the data very manageable.</p> <p>To speed up the responses to your clients I would look at running <a href="http://nodejs.org/" rel="nofollow noreferrer">node</a> on your server.</p> <p>This is because it's event driven and non-blocking.</p> <p>What does that mean?</p> <p>Well, when Client A requests some data that is stored on the hard drive, traditionally PHP might say to the C++, fetch me this chunk of data stored on this sector of the hard drive. C++ would say 'ok no problem', and while it goes of to get the information PHP would sit and wait for the data to be read and returned before it continues it's operations, <strong>blocking</strong> all other client's in the meantime.</p> <p>With node, it's slightly different. Node will say to the kernel, 'fetch me this chunk of information and when your done, give me call', and then it continues to take requests from other clients that may not need disk access.</p> <p>So suddenly because we have assigned a callback to the kernel, we do not have to wait :), happy days.</p> <p>Take a look at this image: <img src="https://i.stack.imgur.com/oGK0K.gif" alt="Node Event Loop"></p> <p>This really could be the answer your looking for, please see the following for a more descriptive and detailed information regarding how node could be the right choice for you:</p> <ul> <li><a href="http://blog.mixu.net/2011/02/01/understanding-the-node-js-event-loop/" rel="nofollow noreferrer">http://blog.mixu.net/2011/02/01/understanding-the-node-js-event-loop/</a></li> </ul>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

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