I'm looking for a light weight database component to replace a large dataset.. currently I have an array that is now growing to 1Million+ rows.. and memory usage isn't that efficient.
When I search through it I just loop throught the array.. I never expected that it would grow this large and now I need to fix the problem of high memory usage.
The data is only relavent for the session, and is retrieved from the server upon login.
Does anybody have a suggestion for a local database that I can compile in? I have found one so far: here http://www.zeitungsjunge.de/delphi/sqlite3/