title: Data storage in JSON/XML files along with MySQL Database is efficient?
body: <p>I searched a lot on <strong>SO</strong> &amp; as well as on <strong>Google</strong>, but did not get an exact answer to my question. So, here is my question.</p>
  
  <p>I am working on a project in which we are <strong>storing our data in the database as well as in the XML files</strong> from back-end <strong>to reduce database load</strong>. And, when we need that data on the front-end, <strong>we call the respective XML files to fetch data</strong>.</p>
  
  <p><strong>Q.1 - I wanted to know, whether it is the best approach to reduce load on the database?</strong></p>
  
  <p>And, I think JSON will be a better alternative to XML as it is light weight. So, my another question is,</p>
  
  <p><strong>Q.2 - Is it efficient to use JSON to store data instead of XML?</strong></p>
  
  <p>Also, we can introduce <strong>memcache</strong> to reduce the same load. But, <em>if data is not available in <strong>memcache</strong>, we have to query the database</em>. <strong>In this case, can JSON/XML data storage come in handy?</strong></p>
  
  <p><strong>Q.3 - Is there any other efficient approach?</strong></p>
  
  <p>I have heard of Apache Cassandra &amp; Hadoop, but it seems that it is good to use these when you are working on a highly scalable application. So,</p>
  
  <p><strong>Q.4 - Is there any Apache Open Source project (for start-up scale) we can make use of?</strong></p>
  
  <p>In short,</p>
  
  <p><strong>Q.5 - What is the best way to <em>STORE &amp; QUERY</em> the data in an efficient &amp; performance oriented way?</strong></p>