User Forum
Xequte User Forums
Profile    Active Topics    Forum FAQ    Search this forumSearch
Forum membership is Free!  Click Join to sign-up
Username:
Password:
Save Password
Forgot your Password?

     
Forum Tips
» This forum is for users to discuss their software problems and suggestions for improvement.  Remember that only a tiny percentage of our users experience such problems (To be precise less than 0.7% have ever posted on this forum)
» Include your software version number (as displayed in the About Box)
» Check the FAQ before posting as most common questions have already been answered
» You don't need to also e-mail us separately as our support team will respond to all questions on this forum
 
 All Forums
 Xequte User Forums
 MailList King
 Why does Business v7.32R clog up?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jbentley1

USA
4 Posts

Posted - Dec 03 2009 :  14:31:57  Show Profile  Reply
I am trying to process 6 million addresses and get them into a mailing list so I can start sending them messages. After processing about 1 million addresses MLK slows down to an absolute crawl. I have been uninstalling it and reinstalling it and it works fine for a while, however I don't think that is addressing the basic problem. Is there some sort of maintenance I can do on MLK to keep it lean and mean and running smoothly at top speed.

xequte

7504 Posts

Posted - Dec 03 2009 :  15:30:19  Show Profile  Reply
Hi

Under View > Options, Other, what are your performance settings?

What are the specs of your PC? Which actions in particular are slow?

Nigel
Xequte Software
www.xequte.com
nigel@xequte.com
Go to Top of Page

jbentley1

USA
4 Posts

Posted - Dec 03 2009 :  16:14:03  Show Profile  Reply
Default settings. Checked boxes are Do not cache, limit to 500; Disable automatic searching; guess Country field; Backup to a file %DB-FOLDER%\BackUp.csv; auto backup - None

The computer is old and slow AMD 1.39 GHz chip, 1 Gb memory, 333 MHz. This will be corrected at XMAS with 3.0 GHZ Intel E8400 chip and 4 GB of 800 MHz memory.

I have been loading addresses (some corrupted) from Excel, 60,000 at a time. MLK does a great job of cleaning out the crap. Then I back up the file. It saves as Excel. I separate out the address column and save it in Notepad (text, one address per line). Then I "Add Addresses" from the backup file and Remove the addresses from the mailing list. After I do this about 15 or 16 times it just won't move anymore.

I have about 2 million more addresses to process out of 6 million. When they are all processed I intend to load my clean text lists into 6 Groups of about 1 million each. Then I plan on sending one email per day to one group of 1 million recipients. Hopefully I will sell some stuff and make this effort worthwhile.
Go to Top of Page

xequte

7504 Posts

Posted - Dec 03 2009 :  20:03:23  Show Profile  Reply
Hi

If you've added a million entries, and then remove them you should use File > Optimize to ensure the database is recompressed.

You might also want to go into View History and Errors and remove extraneous entries from there too.



Nigel
Xequte Software
www.xequte.com
nigel@xequte.com
Go to Top of Page

jbentley1

USA
4 Posts

Posted - Dec 04 2009 :  08:46:25  Show Profile  Reply
Thanks for the tip about File> Optimize. I have tried to delete the history and it takes longer than just reloading the whole program.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To: