nedb icon indicating copy to clipboard operation
nedb copied to clipboard

How to combine and query two databases with same type

Open VigneshVaidyanathan opened this issue 5 years ago • 1 comments

Hello guys, I am new to Ne Db and I am trying to create an Electron app. The db that I am using is currently storing 500kb of data for one day of work. So considering the fact that the user will be using this daily, the size of the db grows considerably in a weeks time, which would make the operations slower.

I don't need to access the week-old or month old data on a day to day basis ie frequency of querying that is less. So I was thinking to split out the week's data into a separate database so only current week's data is present in the active database (much like a log file).

Now when I want to query data from all databases, the only option I got is to query each database and hold the data in memory, merge with the remaining database records and perform the final query. This could significantly increase the memory used since the data is kept at the memory.

Let me know if there is a better way to handle this :D

VigneshVaidyanathan avatar Jul 12 '19 04:07 VigneshVaidyanathan

This is not an issue with NEDB itself. It states clearly on the front page of the repository that only bug reports and feature requests belong in "issues". I suggest you ask on StackOverflow instead.

briggsywxf avatar Jul 19 '19 15:07 briggsywxf