![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General Discussion » View Thread |
Messages 1 to 7 of 7 total |
![]() |
Wed, May 23 2018 10:19 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | I'm trying to help someone out who's Incredimail system has crashed (again) so I'm exporting all the emails and suggesting a less "fun" but slightly more robust system to import back into.
I just want to recommend looking at how they store things as an example of how not to do it! I'm just working off the .imm files (which seem to be th email header & body) but there's also .imh and some SQLite databases and a Messages directory with a load of numerically named folders (1 to 6) each of which contain a load of GUID named folders which may or may not contain anything and if its folders they may or may not be empty. I'm sure it all made sense to those who designed it but WOW. Roy Lambert |
Wed, May 23 2018 7:09 PM | Permanent Link |
Jeff Cook Aspect Systems Ltd | Roy Lambert wrote:
<snip> I just want to recommend looking at how they store things as an example of how not to do it! <snip> Probably wasn't "designed" - just grew like topsy! |
Wed, May 23 2018 11:52 PM | Permanent Link |
Raul ![]() | On 5/23/2018 10:19 AM, Roy Lambert wrote:
> I'm just working off the .imm files (which seem to be th email header & body) but there's also .imh and some SQLite databases and a Messages directory with a load of numerically named folders (1 to 6) each of which contain a load of GUID named folders which may or may not contain anything and if its folders they may or may not be empty. I'm sure it all made sense to those who designed it but WOW. This is not unlike what outlook express (i think) did : - sqlite database would likely be headers and subject and such used by app itself to allow quick display and searching etc - imm/imh files are actual emails as putting them in the sqlite would have blown that one up likely (outlook had eml i think). Can't comment on folder structure but using guid for folder names is not a bad idea from app aspect. Raul |
Thu, May 24 2018 3:47 AM | Permanent Link |
Matthew Jones | Raul wrote:
> using guid for folder names is not a bad idea from app aspect. It sort of fits with the "computer science" idea of hashed buckets too, but I'm not sure it would work well for long term use. On the other hand, a folder with "2018-05" would soon have people poking their noses in trying to be clever. So long as you can rebuild the core from the contents, it probably doesn't matter what you call the directories. The one thing people don't need to learn is that a single directory with hundreds of thousands of emails is not a good idea. Do not do it! I had a little NAS once that I filled a directory with, and it was unable to cope. Even doing a delete would usually time out as it tried to operate on a file. Eventually I wiped the NAS as the only way to recover. Windows, oddly, coped a lot better, but even there I decided to use sub-directories. Umm, this is a discussion of single file databases isn't it? 8-) -- Matthew Jones |
Thu, May 24 2018 4:26 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Matthew
>Umm, this is a discussion of single file databases isn't it? 8-) Funny you should say that ![]() Roy |
Thu, May 24 2018 4:27 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Jeff
>Probably wasn't "designed" - just grew like topsy! Nah. I bet it was designed using all the latest theories or at least the theories that were new c20 years ago Roy |
Thu, May 24 2018 4:37 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Raul
>This is not unlike what outlook express (i think) did : OE was a paragon of cleanliness by comparison with IncrediMail >- sqlite database would likely be headers and subject and such used by >app itself to allow quick display and searching etc Headers (sort of) & lists of directories (I think) >- imm/imh files are actual emails as putting them in the sqlite would >have blown that one up likely (outlook had eml i think). Yup OE used .eml and not much else its problem was it couldn't handle large amounts of data - the full DBISAM & ElevateDB & WPTools & embarcadero newsgroups I maintained in DBISAM wouldn't work - its why I rolled my own ![]() The ,imm files seem to be emails the .iml files are something else - not sure what. When IncrediMail bombs its usually the sqlite db that's corrupted the various mailboxes are ok(ish) >Can't comment on folder structure I can, but not in polite society! Roy |
This web page was last updated on Monday, July 15, 2024 at 07:03 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |