User Forum
Xequte User Forums
Profile    Active Topics    Forum FAQ    Search this forumSearch
     
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
 Slow removing members

Note: You must be registered in order to post a reply.

Size 
UserName:
Password:
Mode 
Format  BoldItalicizedUnderline Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailBrowse for an image to attach to your post Insert CodeInsert QuoteInsert List
   
Message 

 

Emoji
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Black Eye [B)]
Frown [:(] Shocked [:0] Angry [:(!] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
JordanWebmaster Posted - Oct 23 2017 : 03:35:17
Slow removing members,
Version: 17.11.803.911

My database is about 250.000
I wanna remove 20.000 from it but it takes more than 5 hours to finish.

How can i speed up this process.?
1   L A T E S T    R E P L I E S    (Newest First)
xequte Posted - Oct 23 2017 : 23:03:13
Hi

There are a number of options that can slow down deletion, particularly if you have enabled options such as sending confirmation or advisory messages to users.

What method did you use to delete the members? The standard "Delete Member"? Then which of the options did you choose?

Also, ensure that your history log is not too large. Go into File > Options, Database, click Optimize Now and use the options to reduce the size of your database.



Nigel
Xequte Software
www.xequte.com
nigel@xequte.com