Performance with huge databases

Legacy MyInfo versions topics and topics that are no longer relevant
Locked
Achim
Posts: 4
Joined: Wed Jul 16, 2008 9:55 pm

Performance with huge databases

Post 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
Petko
MyInfo Support
Posts: 3339
Joined: Sun Jul 25, 2004 4:33 pm
Contact:

Post 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.
Locked