Moving from Oracle to MariaDB - Source

Revision: 41715
User: Vignesh Sambasivamurthy
Date: 2016-02-28 14:36

Hi,

We are conducting some POC to move our application from Oracle 11g to MariaDB 10.1.
During the testing we find that the response for the below kind of query is very slow.
Please help on below,
1. Is there any configuration that will help to make the response time better
2. Is this a know limitation/issue. If so, which release can we expect the fix
<<code>>
server1> select count(*) from t1;
+----------+
| count(*) |
+----------+
|      163 |
+----------+

server1> explain select id from (select id from t1) t2 where id=1;
+------+-------------+-------+------+---------------+---------+---------+-------+------+-------------+
| id   | select_type | table | type | possible_keys | key     | key_len | ref   | rows | Extra       |
+------+-------------+-------+------+---------------+---------+---------+-------+------+-------------+
|    1 | SIMPLE      | t1    | ref  | t1_idx1       | t1_idx1 | 5       | const |    1 | Using index |
+------+-------------+-------+------+---------------+---------+---------+-------+------+-------------+

Regards,
Vignesh

Answer

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

Moving from Oracle to MariaDB - Source

Answer

Products

Services

Pricing

Resources

About Us

Download MariaDB