Speed

Speed - We like it fast

Thats why we make sure to use all the tricks we can find to make javascript spit out your results as quick as possible. Among other things we make sure that:

• Queries are cached as compiled functions.
• Joined tables are pre-indexed
• WHERE expressions are pre-filtered for joins

But dont take our word for it. Check out AlaSQL vs other JavaScript SQL databases:

• AlaSQL vs. WebSQL - Mixing SELECT, SUM, JOIN, and GROUP BY on fake data (in-memory opperations for both - see this discussion)
• AlaSQL vs. SQL.js - Mixing SELECT, SUM, JOIN, and GROUP BY on fake data
• AlaSQL vs. Linq - GROUP BY on 1,048,576 rows

Every part must be optimized, so lets compare some cases where you would often use another library:

• Sorting with Alasql vs Lodash vs Underscore vs. vanilla js - Sorting via SQL does not ned to be so far from vanilla javascript speed
• Finding the right data AlaSQL vs. CrossFilter
• Finding the right data AlaSQL vs. CrossFilter 2
• Grouping AlaSQL vs. handcrafted javacsript - based on SatckOverflow question on grouping.