I am looking to move my current architecture to MySQL Cluster 7 to achieve better performance for web application for read and write.
I know data is partitioned on primary key basis. Can anyone help me to know how is the performance to select data from multiple partitions ?
Let suppose i have one table having 3000 records and data is partitioned on primary key basis in such a way
partition A 1-1000 records
partition B 1000-2000 records
partition C 2000-3000 records
when i query from SQL Node How is performance for the queries and how those queries going to be handled by transaction coordinator.
SELECT * FROM table WHERE id BETWEEN 1 AND 1000; (partition A)
SELECT * FROM table WHERE id BETWEEN 500 AND 1500; (partition A & B)
SELECT * FROM table WHERE id BETWEEN 500 AND 2500; (partition A,B & C)
Thanks in advance.