Altova DatabaseSpy vs. FlySpeed SQL Query vs. dbForge Query Builder for SQL Server vs. memcached Comparison Chart

The visual query designer lets you create new SQL queries by drag'n'drop, and represent off-the-shelf queries visually. It makes SQL query analysis, creation, and modification much simpler. Using FlySpeed SQL Query, you can build parameterized queries, and browse data from linked tables via foreign keys. Your queries will be saved along with the database connection right beside the database object tree, so you'll be able to continue your work from the point where you stopped last time. The history of SQL query execution is saved automatically; all the settings used during your last session will be restored the next time you start FlySpeed SQL Query. The special Portable version will allow you to keep your database connection settings and queries at your fingertips. Install FlySpeed SQL Query to your cloud folder, network or portable drive and get access to your data and settings from all of your workstations.

You can think of it as a short-term memory for your applications. memcached allows you to take memory from parts of your system where you have more than you need and make it accessible to areas where you have less than you need. The first scenario illustrates the classic deployment strategy, however you'll find that it's both wasteful in the sense that the total cache size is a fraction of the actual capacity of your web farm, but also in the amount of effort required to keep the cache consistent across all of those nodes. With memcached, you can see that all of the servers are looking into the same virtual pool of memory. Also, as the demand for your application grows to the point where you need to have more servers, it generally also grows in terms of the data that must be regularly accessed. A deployment strategy where these two aspects of your system scale together just makes sense.