| 
| 
Why Select Lava Distributed SQL?
Capacity for Huge Databases
Very large databases require a number of crucial facilities. The first is the ability to create large numbers of data tables (potentially in large numbers of schemas). This is a relatively easy requirement, which can be filled by most capable databases.
The next requirement is more difficult. Several of these tables must be extendable to potentially hundreds of millions of rows of data. Lava distributed SQL is capable of extending any number of tables to and beyond 1 billion rows of data.
The requirement for data access is tougher still. In order to be able to manipulate these huge data tables, indexing and row access must be very fast. This is where the Lava system excels. Indexed access to rows in huge tables is the fastest available.
As can be seen in the example above, selecting 100 rows from a 200 million row table using an index will take around 15 milliseconds when selecting from the server directly.
Finally, it must be possible to add new data into a large table quickly. Due to the architecture of the database and the performance of table access, very large databases still offer very high performance. For example, a data table of 120 million rows with 2 indexes will still allow row insertion rates of around 15,000 rows per second on even a moderate client and server without any special hardware.