SchemafreeSQL delivers fast index-like queries without index configuration AND at the same time
delivers inserts at fast no-index speeds.
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…
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 combinations 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 your table had 50
columns, there would be over 5 million four column combinations!
Fortunately, SchemafreeSQL removes this problem from your plate.
With SchemafreeSQL, you get indexing for free.
Not even a second of your time will be wasted on index design or
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 (hypotheical) composite
indexes without the downfalls.