Page 1 of 1

Performance with huge databases

Posted: Sun Jul 20, 2008 11:44 am
by Achim
Hello,

I'm currently evaluating version 4.02 and MI seems to fit my needs far the best, (i.e. it has the fewest shortcomings compared with the other ca. 50 Organizers and Outliners I tested through the last 5 years). I think it's a really useful and mature piece of software, with a solid and ergonomic design. So im heavily considering to buy it (tarrying not because of the price - it's absolute fair - but because of the time, a new software costs, till you seriously get it to work.)

Nevertheless, there is a point I would like to be sure about:

I have to handle a lot of text (rtf-) files - maybe 20.000 or more - and hence would like to know if MI is capable of doing that. OK, I could split them in different topics, but due to working conveninence they would be still about 200 to 400 MBs. It was frequently mentioned, that MI-databases are only limited by system resources.
  • - Now, RAM is a system resource and HD capacity is another one. Which of them sets the limit?
    - Could a DB of this size opened and handled in reasonable time - considering there are huge zip-archives to be unpacked/packed? (and if not - might there be a chance to turn off zip compression? And indexing too?)
    - Did you do some tests with big databases and have maybe some experiences regarding size vs. performance?
Have also a lot of wishes, visions and suggestions, but they should go into a new threat.

best regards and thanks for this fine software

Achim

Posted: Tue Jul 22, 2008 5:38 pm
by Petko
Achim, MyInfo could work with very big databases, but generally for such big files (> 200 MB uncompressed data, which can be any compressed MyInfo file with size > 20 MB) is getting slow. And even, if there is way to turn off the compression (indexing is not a big problem here), it is still slow for most machines.

So, if you want to use MyInfo for these file, you have to split them into smaller files.