I wonder, is there a limit for the size of My Notes?
Looking at this, I'm not too sure what you mean regarding the size as to:
- the amount of data entered into your note
- or the amount of data entries entered into that particular note database.
So, I'll take a stab at both of them, and trust that it will help you.
OK, here goes. Irrespective of the type of Database system one uses (as this is what e-Sword is based on), there are limitations to that system, which are:
- The total amount fields
- The total amount of records per field
- The total amount of characters per record
Now with that, all Database systems suffer from those limitations whether they are Relational or Object Oriented systems. Object Oriented Databases are a much more powerful system than Relational Database Systems in the total amount of data they can carry. As to what those figures are, I don't know.
OK, having said all that, when it comes to e-Sword Note database files in how much data they can handle is totally dependent on the limitations of SQLite, and for that kind of information you need to read the technical data for that system.
The most powerful Relational Database System touted is PostgreSQL with Oracle coming in as the second most powerful. The most powerful Object Oriented system is Jade, of which, from my understanding, is its capacity outstrips any Relational system.
Just to let you know, when it comes to databases, they hate me. I crap out terribly when it comes to designing and creating databases. Yet I have an incredible understanding of how they work. Its one of those things, where I can get right into the theory of them and love to pull them apart to see how they work. That's gotta be crazy.
Edited by APsit190, 16 January 2018 - 01:47 PM.