Re: Large Database
Thanks everyone for all the good advice! After religiously backing up my entire mail folder, I compacted my mail database. The entire process took about 15 minutes, much less than I had feared, and trimmed the database size from 1.9 GB to 481 MB. Yay! This gives me more breathing room before I'm forced to export older messages to a separate db. -- marco -- It's not the data universe only, it's human conversation. They want to turn it into a one-way flow that they have entirely monetized. I look at the collective human mind as a kind of ecosystem. They want to clear cut it. They want to go into the rainforest of human thought and mow the thing down.
Re: Large Database
Watch for line breaks. Disclaimer: I don't deserve credit for this script. Unfortunately I don't remember who does. :-( Andy applescript property preMsg : You currently have: return property postcC : Message folders property postfC : Message Filters property postclC : Text Clippings property postsigC : Signatures property postMsgs : Messages property bttnList : {Thanks, Put on Clipboard} property defBttn : Put on Clipboard to concatenateData(cCnt, fCnt, clCnt, sigCnt, ctMsg) return (preMsg ctMsg postMsgs return cCnt postcC return fCnt postfC return clCnt postclC return sigCnt postsigC) end concatenateData to displayTotals(statsTxt) set the dialogBttn to the button returned of (display dialog statsTxt buttons bttnList default button 2) if the dialogBttn is the defBttn then set the clipboard to the statsTxt beep end if end displayTotals tell application PowerMail set the containerCnt to count message container repeat with i from 1 to containerCnt set subContainerCnt to count message containers of message container i set containerCnt to containerCnt + subContainerCnt end repeat set the filterCnt to count filters set the clipCnt to count text clippings set the sigCnt to count text signatures set ctMsg to 0 repeat with acontainer in every message container set ctMsg to ctMsg + (my count_messages(acontainer)) end repeat set the statsTxt to my concatenateData(containerCnt, filterCnt, clipCnt, sigCnt, ctMsg) my displayTotals(the statsTxt) end tell -- The above will count your PowerMail; message folders, filters, text clippings -- and the text signatures and display the information in a dialog. -- The dialog will give you an option to put the entire results -- onto the clipboard. (* this recursive function receives a message container (folder). It first calls itself for every sub-container of the input container, summing up the number of messages stored in them, and last, adds the number of messages in the input container itself. *) to count_messages(input_container) tell application PowerMail set c to 0 repeat with bcontainer in every message container in input_container set c to c + (my count_messages(bcontainer)) end repeat set c to c + (number of messages in input_container) return c end tell end count_messages /applescript -- Andy Fragen On Mon, Dec 26, 2005, Sean McBride said: Jim Pistrang ([EMAIL PROTECTED]) on 2005-12-26 16:44 said: Just curious, what is the total number of emails in your database? I Is there an easy way to tell? I have so many folders looking at each and adding them would be a pain. :) -- I object to violence because when it appears to do good, the good is only temporary; the evil it does is permanent. - Gandhi
Re: Large Database
Jim Pistrang ([EMAIL PROTECTED]) on 2005-12-26 16:44 said: Just curious, what is the total number of emails in your database? I Is there an easy way to tell? I have so many folders looking at each and adding them would be a pain. :) -- I object to violence because when it appears to do good, the good is only temporary; the evil it does is permanent. - Gandhi
Re: Large Database
Hi Marco, I've been using PowerMail for a more than two years now, and I've become totally addicted to the FoxTrot search feature. I use FoxTrot to instantly find interesting threads in a handful of technical mailing lists that I don't have the time to read day to day, but keep archived for later reference. One of this lists has accumulated in excess of 38,000 messages. Today, for the first time, it looks like I hit some hard limit, because the following dire warning popped up: Your database is near 2 GB Just curious, what is the total number of emails in your database? I have over 40,000 and my database is at 150mb. Unless you have a huge number of emails, there may be something else going on here. I recommend that you first make a copy of your database, then try to compact it. Jim -- Jim Pistrang JP Computer Resources Certified Member, Apple Consultants Network 413-256-4569 http://users.crocker.com/~pistrang
Large Database
I've been using PowerMail for a more than two years now, and I've become totally addicted to the FoxTrot search feature. I use FoxTrot to instantly find interesting threads in a handful of technical mailing lists that I don't have the time to read day to day, but keep archived for later reference. One of this lists has accumulated in excess of 38,000 messages. Today, for the first time, it looks like I hit some hard limit, because the following dire warning popped up: Your database is near 2 GB PowerMail can't handle a message database larger than 2 GB. You should compact your database, or export old messages and delete them from your database. So far I haven't really deleted any messages except spam, so I don't think compacting my database will help much except perhaps put off cleaning it out for a few more days. It sounds like the moment has come, but I really don't want to lose the ability to search old messages. What are my options? Can I export folders in a format that FoxTrot Personal Search can index? Are there any plans to support databases larger than 2 GB in a future version of PowerMail? With hard disks getting larger and cheaper by the day, two gigs look like a pretty small limit. -- marco -- It's not the data universe only, it's human conversation. They want to turn it into a one-way flow that they have entirely monetized. I look at the collective human mind as a kind of ecosystem. They want to clear cut it. They want to go into the rainforest of human thought and mow the thing down.