Re: Large Database
I would definitely try compacting the database anyway. Mine often goes down to 50%of its current size, and this can't be due only to the fact I deleted a bunch of emails. Compacting may take anything between 10 minutes and an hour, depending on your type of machine. Olaf [EMAIL PROTECTED] wrote Mon, 26 Dec 2005 18:15:38 +0100 >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. > > >
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
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
--
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
On Mon, 26 Dec 2005 16:44:08 -0500, Jim Pistrang ([EMAIL PROTECTED]) wrote: >Just curious, what is the total number of emails in your database? 89,218 >I have over 40,000 and my database is at 150mb. So, assuming the same average message size, my database should weigh in at about 150*(89,218/40,) = ~334 MB, much less than its current size of 1.9 GB. I'll definitely try compacting it, then. >Unless you have a huge number of emails, there may be something >else going on here. Could it be that my DB has *never* been compacted since I started using PowerMail? On Mon, 26 Dec 2005 17:18:12 -0500, Sean McBride ([EMAIL PROTECTED]) wrote: >Jim Pistrang ([EMAIL PROTECTED]) on 2005-12-26 16:44 said: > >>Just curious, what is the total number of emails in your database? > >Is there an easy way to tell? I have so many folders looking at each >and adding them would be a pain. :) I have dozens of folders, too, so I whipped up a script that lists all folders and subfolders with their respective message counts, and totals them up. -- 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
Hi Sean, >Is there an easy way to tell? I have so many folders looking at each >and adding them would be a pain. :) Do a search for all emails with a date sent that is less than tomorrow. The resulting list will have a message count. Jim -- Jim Pistrang JP Computer Resources Certified Member, Apple Consultants Network 413-256-4569 http://users.crocker.com/~pistrang
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
Re: Large Database
Marco Piovanelli sent on Mon, 26 Dec 2005 18:15:38 +0100 >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 One option, which I have used, is to save the existing database under another name (such as "Emails 1998-2005"). Then go to your current database, and delete all of the older stuff. In the saved database, go to Mail... Scheduling and Locations, and be sure to turn off scheduled email retrievals. That way, when you go to the old database to search, it won't retrieve new mail When you need to search for a message in the older database, just go to File... Database... Switch User Environment. The select the older database. Howard
