Hello,
I just started using Siaqodb.
I'm testing it to see if it could be suitable for our needs (updating a single object with lots of items).
Our current SQL database is nice for searching data but it's a nightmare when we have to update thousands of items.
Siaqodb could do the job, but it the Store operation takes a lot of time and I keep getting a MDB_DBS_FULL: Environment maxdbs limit reached exception in the end.
Here is the code:
SiaqodbConfigurator.AutoGrowthSize = 25 * 1024 * 1024;
Siaqodb siaqodb = new Siaqodb(objPath, 800 * 1024 * 1024); // DB size set to ~800MB
object resObj = MethodToParseJsonAsC#Object(....);
EventJson root = resObj as EventJson;
siaqodb.StoreObject(resObj);
I tried to use Transaction but it doesn't change anything.
I'm doing this test under Windows 10 PC, I set the DB size to 800MB to be sure it doesn't come from DB size limitation.
I'm using a Trial Key (received yesterday).
The serialized Json object size is 11MB
The Json object contains thousands of children and subsubsubsub children.
As I'm on a PC, I guess that the huge amount of time it takes before throwning the exception doesn't come from the disk speed nor the CPU speed.
But I'd like to make it works to do proper performance tests.
If someone as any idea, or advice, it would be greatly appreciated.
Regards,
Damien