SchemafreeSQL delivers fast indexed queries without index configuration AND at the same time
maintains predictable insert speeds by avoiding myriad composite indexes.
As applications grow, the diversity of queries grow. To maintain acceptable query performance, it is common practice to create new
indexes on both single columns and combinations of columns.
However, when trying to create a composite index for every possible
combination of queried column sets, you run into a serious problem which we'll refer to as the "Index Permutation Limitation".
For example, suppose you had just 10 columns on a table but user
demands kept growing as to what columns they wanted to filter against.
Even if the users only filtered against 3 of the 10 columns, there
are 720 possible permutations of 3 column sets (10!/(10-3)!).
Of course, you won't get close to making that many indexes anyway,
as SQL databases have a hard (and practical) limit on how many you can
create and/or how large your indexes can be.
MyISAM for instance, has a limit of 64 indexes per table,
and InnoDB has restrictions on the number of bytes per index (3072 bytes or about 768 chars).
But regardless of the database limits, if you actually had 720
indexes on a table, INSERT speed would most likely grind to a halt.
And this is only a simplistic scenario. If you wanted to cover every 5-column index permutation across 50
columns, there would be over 254 million indexes to create!
Fortunately, SchemafreeSQL removes this problem from your plate.
With SchemafreeSQL, you get indexing for free. Well, nothing's free
of course, but this is as "free" (i.e. cost vs benefit) as is practically possible.
Not even a second of your time will be wasted on index design or
optimization. A single dedicated-compound-index may be faster on it's own, but
SchemafreeSQL can give you near single-dedicated-compound-index speed across ALL of those 254+ million
possible index permutations (from the choose 5 out of 50 problem).
And in case you are worrying - no, we are NOT creating composite
indexes on demand in reaction to your queries. SchemafreeSQL provides
you with the benefits of vast numbers of composite indexes, but without the downfalls.