I am looking for some quick embedded DB for .net 4 (preferably in memory).
My usual operations are very simple: if one large table contains about 50 columns and 30 thousand rows (can reach 1 m), make queries like SELECT AVG (col1) FROM table WHERE col2 IN (?) AND col3 IN (?) And col4 <?, SELECT col1 FROM table WHERE [same], etc. Columns are rows or floating elements.
I started with simple .Net DataTables + LINQ, which are pretty fast, but obviously limited in size (it crashes long before there is no ram on the left). There are also no indexes that I thought should improve performance.
Then I tried SQLite (devart adapter) with SQL queries, which is about 10 times slower than in datatables memory. I made indexes on all columns in this table, but that did not help. I thought SQLite was considered one of the fastest built-in databases, so this is pretty disappointing.
Is there a fast and scalable alternative? For instance. something like a DataTable with indexes that can use up a lot of memory (for example, I don't mind that he will have some gigs).
source
share