by ivan stimac (8 Submissions)
Category: Databases/Data Access/DAO/ADO
Difficulty: Advanced
Date Added: Wed 3rd February 2021
Rating: 
(3 Votes)
Hi, there is a new version of SmallDBEngine. New version support indexing, and it's much faster (read/delete). Now RecordSet read records from file: MoveNext find pointer to next row and then reads only this row (v.1 reads all records and save them into array, what is slow and use much memory). There is also a class to export whole DB into sql file.
This is only sample project, so don't expect so much from it. You can see one way to create indexing. NOTE: this project support only TEXT fileds (and also only indexing by text, if you want more effective search you must create column data types and create indexing for each data type). I'm created a template for project with custom data types, and I'll create a code when find some time for this.
Download Small Database Engine 2 (34 KB)
VBcoders