maria-discuss team mailing list archive

[Daniel Bartholomew <dbart@xxxxxxxxxxxxxxxx>]

A new question has been posted to the Knowledgebase:

http://kb.askmonty.org/en/indexoptimizations-in-dynamic-columns
---------------------------------------------------------------------
Greetz to all...

I have been playing with the dynamic columns in MariaDB 5.3...

Running your test queries I decided to do an explain on one of them:

MariaDB [test]> explain SELECT name FROM t1 WHERE COLUMN_GET(dynstr, 1
as char(10)) = "red";
+----+-------------+-------+------+---------------+------+---------+------+------+-------------+
| id | select_type | table | type | possible_keys | key  | key_len |
ref  | rows | Extra       |
+----+-------------+-------+------+---------------+------+---------+------+------+-------------+
|  1 | SIMPLE      | t1    | ALL  | NULL          | NULL | NULL    |
NULL |    4 | Using where |
+----+-------------+-------+------+---------------+------+---------+------+------+-------------+
1 row in set (0.00 sec)

I was just curious, do dynamic columns suffer from the same perf
penalties at scale that non-indexed or function-based where criteria do?

If they currently do, are there currently any plans to index/optimize
dynamic columns for super fast at-scale data access?

Best,

Joshua
---------------------------------------------------------------------

Thanks.

-- 
Daniel Bartholomew
MariaDB - http://mariadb.org
Monty Program - http://montyprogram.com
AskMonty Knowledgebase - http://kb.askmonty.org