-
Q excels in generating and querying large datasets due to it’s capability of performing efficient vector based operations; you’ll see more benefit with Q the larger your dataset becomes.
“Column Oriented SQL tables are organized as rows distributed across storage and operations apply to fields within a row. Q tables are column lists in contiguous storage and operations apply on entire columns.” – (Jeffry Borror, 0. Overview – Q for Mortals (kx.com))
In terms of resources, there are a lot of options. Here are a few ideas to get started:
Check out this blog for some more insight What Makes Time-Series Database kdb+ So Fast? | KX along with other material on code.kx.com, in particular whitepapers and the Community.
The sales brochure and blog also contain a lot of useful information around performance.
Hope you find this insightful