on 2017 Sep 20 6:31 AM
Having started with Watcom 5.0 I have played with SQLAnywhere for a number of years, building bigger and better servers with faster arrays of spinning rust etc. all slowly giving increased performance.
Then came SSDs and the advantages of massively parallel IO should now have a major impact on the throughput of the database, especially for VALIDATE or other random IO solutions. And yet this has not materialised.
In 2014 Pedram Ghodsnia, Anisoara Nica and Ivan Bowman published the interesting paper “Parallel I/O Aware Query Optimization” where this subject was analysed and a proposal for QDTT put forward. Where is the ability in 16 or 17 to implement something of this nature?
I have a customer who are trialling a SSD array on 16GB FC, SQLA is optimising this as a single disk and therefore throughput is terrible!
Am I the only one who thinks that disk throughput/ I/O has in the fallen away from what is available in SSD/Hybrid disks and is impacting on SQLA as a result?
Thanks
Request clarification before answering.
User | Count |
---|---|
76 | |
30 | |
8 | |
8 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.