When dealing with row by row inserts, or developing front ends, all three databases above far exceed SAP IQ's performance. It struggles when trying to do individual small transactions.
When doing massive bulk transactions, or extensive queries, SAP IQ outperforms all three by …
SAP IQ is perhaps an under-marketed product in the sense that it is able to scale up very well and perform much faster and more efficiently than other products such as Oracle - when we ran multiple large queries on both Sybase IQ and Oracle, we found that that results were much …