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.
