CintaNotes Forum

Are there any recommendations or size limitations for the size of individual notes as well as for the number of notes in a database? Is there some point where everything starts to slow down too much? I suspect it's much more than I need, but I'm curious what sizes you use when testing with 'large' databses.

Gunars

Hi gunars,

this question comes up so regularly, that I'll definitely include it in the FAQ!

Here are links to previous discussions on that topic:
viewtopic.php?f=3&t=1642
viewtopic.php?f=3&t=183
viewtopic.php?f=3&t=77

I regularly test with DB sizes of about 50MB.
If your notes are small (100kb or less), the noticeable slowdown begins at about 5000 notes in one section.

CintaNotes Developer wrote:I regularly test with DB sizes of about 50MB.
If your notes are small (100kb or less), the noticeable slowdown begins at about 5000 notes in one section.

Thanks, Alex! As I said, it more than meets my needs. Why a slowdown by section though? Is each section indexed separately?

Gunars

gunars wrote:Why a slowdown by section though? Is each section indexed separately?

By overall "speed" I usually understand the speed of search (especially search inside words, which, being unable to use the full text index, depends linearly on the size of input and thus tends to degrade first). Sections divide the whole body of notes into several parts which are pre-filtered, thus greatly reducing the load. Of course this speedup doesn't apply when you search all sections at once.