1. Full table Query
List the data in the entire table. I don't know why. BerkerlyDB is slower than SQL Server. If there is no reason, I may be useless.
2. getByPrimaryKey
In the case of 19 fields in a table with 33606 data entries: the performance of BerkerlyDB is about 10 times faster than that of SQL Server. (The SQL Server database is also deployed on the local machine)
For tables with 33606 data records, there are two fields in total: the performance of BerkerlyDB is about 500 times faster than that of SQL Server. (The SQL Server database is also deployed on the local machine)
(To be supplemented)
3. Use indexes.
For a table with a total of 19 fields of 33606 data records, two records are returned, using string indexes: the performance of BerkerlyDB is faster than that of SQL Server by 50 ~ About 100 times. (The SQL Server database is also deployed on the local machine)
4. insert data
Insert 2000 entries into the data table, 19 fields in total. SQL Server uses the JDBC executeBatch, with 1000 records in each batch. Berkerly DB uses comiteNoSync to submit data inserted each time. BerkerlyDB is about 10 to 10 faster than SQL Server ~ 20 times.
