title: Am I using cassandra efficiently?
body: <p>I have these table </p>
  
  <pre><code>CREATE TABLE user_info (
      userId uuid PRIMARY KEY,
      userName varchar,
      fullName varchar,
      sex varchar,
      bizzCateg varchar,
      userType varchar,
      about text,
      joined bigint,
      contact text,
      job set&lt;text&gt;,
      blocked boolean,
      emails set&lt;text&gt;,
      websites set&lt;text&gt;,
      professionTag set&lt;text&gt;,
      location frozen&lt;location&gt;
  );
  
  create table publishMsg
  (
      rowKey uuid,
      msgId timeuuid,
      postedById uuid,
      title text,
      time bigint,
      details text,
      tags set&lt;text&gt;,
      location frozen&lt;location&gt;,
      blocked boolean,
      anonymous boolean,
      hasPhotos boolean,
      esIndx boolean, 
      PRIMARY KEY(rowKey, msgId)      
  ) with clustering order by (msgId desc);
  
  create table publishMsg_by_user
  (
      rowKey uuid,
      msgId timeuuid,
      title text,
      time bigint,
      details text,
      tags set&lt;text&gt;,
      location frozen&lt;location&gt;,
      blocked boolean,
      anonymous boolean,
      hasPhotos boolean,
      PRIMARY KEY(rowKey, msgId)      
  ) with clustering order by (msgId desc);
  
  CREATE TABLE followers
  (
      rowKey UUID,
      followedBy uuid,
      time bigint,
      PRIMARY KEY(rowKey, orderKey)
  );
  </code></pre>
  
  <ol>
  <li><p>I doing 3 INSERT statement in BATCH to put data in <code>publishMsg</code> <code>publishMsg_by_user</code> <code>followers</code> table.</p></li>
  <li><p>To show a single message I have to query three SELECT query on different table:</p></li>
  </ol>
  
  <p><code>publishMsg</code> - to get a publish message details where <code>rowkey</code> &amp; <code>msgId</code> given.</p>
  
  <p><code>userInfo</code> - to get <code>fullName</code> based on <code>postedById</code></p>
  
  <p><code>followers</code> - to know whether a <code>postedById</code> is following a given topic or not</p>
  
  <p>Is this a fit way of using cassandra ? will that be efficient because the given scanerio data can't fit in single table.</p>