Main > Software Forum
FE with custom categories?
Lilwolf:
As for speed, no way can any database beat everything loaded in memory and sorted in a list (when you access it linearly).
trouble is sorting is slow. finding the next alpha value (a -> first b) this is a linear search... but still 100% instant.
Where databases are really great.... when you can't load everything at once, sorting, changing the sort at runtime, having multiple keys, reliability, speed of writing code, expandability, accessablitiy for other applications... I'm sure the list goes on.
but pure speed. I have an array that I step through. Cant get faster then that with a disk access.
Howard_Casto:
agreed.... I've found you can store virtually everything contained in the listinfo file in memory without harming resources a bit. My only problem right now is my gui is slower than my searches. :)
I've found that a linear compare of an entire list is just as fast if not faster than using a database query. A database is a lot less likely to screw up, but you pay for it in the hassles of interfacing/packaging and overall loss of speed for conntections/queries.
It really is personal preference, but until I find something a database can do for me that I can't do easier by myself, I'll stick to my pre-sorted text files.
ErikRuud:
Rick,
I don't have Nesticle, so I don't know fi I can help.
It sounds like you are sending a bad option to Nesticle and causing it to lock up.