Re: Query Slowness

[laptop alias]

Incidentally, the usual method for querying against the eav method is to first resolve it as a pseudo normalised table. The pattern for that is as follows...

SELECT * FROM eav_hell;
+--------+----------+---------------+------+
| app_id | question | answer        | user |
+--------+----------+---------------+------+
|    245 | country  | Uganda        |  654 |
|    245 | email    | [e-mail] |  654 |
|    245 | name     | Bob Smith     |  654 |
|    245 | state    | NY            |  654 |
|    245 | status   | 0             |  654 |
+--------+----------+---------------+------+

SELECT app_id
     , user
     , MAX(CASE WHEN question = 'country' THEN answer END) country 
     , MAX(CASE WHEN question = 'email' THEN answer END) email
     , MAX(CASE WHEN question = 'name' THEN answer END) name
     , MAX(CASE WHEN question = 'state' THEN answer END) state
     , MAX(CASE WHEN question = 'status' THEN answer END) status
     , MAX(CASE WHEN question = 'alias' THEN answer END) alias
  FROM eav_hell 
 GROUP 
    BY app_id
     , user;

+--------+------+---------+---------------+-----------+-------+--------+-------+
| app_id | user | country | email         | name      | state | status | alias |
+--------+------+---------+---------------+-----------+-------+--------+-------+
|    245 |  654 | Uganda  | [e-mail] | Bob Smith | NY    | 0      | NULL  |
+--------+------+---------+---------------+-----------+-------+--------+-------+