View Single Post
Old 07-07-2021, 03:48 AM
Spliff Spliff is online now
Registered User
Join Date: 04-07-2021
Posts: 72
Sorry, Kyle, I hadn't seen your post but just now, together with cnewtonne's.

As said over several threads, I got all sorts of problems with too big a database, not only for search, but some days ago, I finally defragmented my HDD - I must admit I hadn't thought of defragmenting it for a very long time, and with a 1GB- or even bigger database, it's obvious that fragmentation will almost certainly become a real problem, so I've come back here today in order to mention this very important fact, which obviously puts into perspective all of the above.

After the defragmentation, I haven't seen any real change though (with my now 60,000 items and lesser databases), the greying-out of cut items (^x) having been, gradually (!), come back even before, depending on the "part" of the database, and around 15 seconds' "wait" upon loading having persisted beyond the defragmentation (i.e. it's as before).

I discovered that most defragmentation tools - even most of the free ones! - allow for defragmentation of just specific folders and/or files, so after a big defragmentation, it will probably be sufficient to just defragment your UR databases (i.e. *.urd in some specific folder), again and again.

Thus functionality is quite hidden, in most tools, and just available indirectly, so for example, in my O&O Defrag Pro, it's in Settings (button, not menu), then Files, then Excluded Files (!) where I put D:\*.*, then "Files that must be defragmented", in which I then put D:\UR\*.*; in other such tools, it's similar, judging from some screenshots / "manual" info.

Notable paid tools are O&O Defrag Pro ($30 for 1), PerfectDisk Pro ($40 for 3, $60 for all home), UltraDefrag ($20 for 3, $40 for all home, not to be mixed up with UltimateDefrag ($30, from the interface you would think it's W95); all of them allow for this individual defragmentation;

Diskeeper is finished, it's DymaxIO now, now rent, from $50 per month (!) onward (no joke, that's for 5 PCs, but you have to pay for them if you need them or not);

notable free tools which, from my web information, also allow for individual defragmentation, are GlarySoft Disk SpeedUp and Defraggler; I'm not sure about Auslogics Disk Defrag though; there's also Puran Defrag (also with that functionality, but which had been deemed "dangerous for your files", but to say it all, that info is from 2012...).

Ideally, SQLite software like UR should "reserve" some HDD space "right after" its current HDD space, e.g. if there is a 1 GB SQLite file, the "next" 500 MB or so should not be marked as "free" for the NTFS file system; technically, it seems that should even be possible, but then only by already writing dummy data there, which will then, gradually, be replaced by real data, and ideally, the SQLite application would rewrite the whole data, again "reserving" additional space, on another place on the HDD when the "reserved" space is going out.

As for such functionality in any defragmentation tool, I didn't find any hint to such a thing, but I suppose that would be technically impossible from that side; as said, from the SQLite application side, it would be technically possible indeed but be deemed somewhat "exotic".
Reply With Quote