How To Do... |
Post Reply 
|
| Author | |
Dan B 
Senior Member 
Joined: 09 February 2005 Location: United States Status: Offline Points: 105 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: How To Do...Posted: 14 March 2004 at 10:15pm |
|
I have a question on how to do this.. We have a list of customers that do not want to view their quarantine messages that SF catches. They just want SF to delete them. I would like SF not to insert them into the database for those customers. Maybe with a option to place those email addresses into a file that SF can reload alone with the other files. Thanks, |
|
 |
|
|
Desperado
Senior Member
Joined: 27 January 2005 Location: United States Status: Offline Points: 1143 |
Post Options
Thanks(0)
Quote Reply
Posted: 15 March 2004 at 9:17am |
|
Dan, I do this with a stored procedure in MS-SQL. I use the tblLogins table to determine if a user has registered and if not OR if they have never accessed their login, once a day I set the expire bit to "1". Unfortunatly, this causes an ultra high load on the SQL server when it triggers for the better part of 10 minutes but I live with that. Also, I am VERY new to Stored procedures so I am very sure it can be done better but have not yet persued it ... bigger fish to fry at this time. Dan S. |
|
|
|
|
Desperado
Senior Member
Joined: 27 January 2005 Location: United States Status: Offline Points: 1143 |
Post Options
Thanks(0)
Quote Reply
Posted: 15 March 2004 at 9:21am |
|
Dan, After reading a post of yours the states how large your DB is, I would not recomend my solution. My DB is only at arounf 10GB and it is a strain on the server. Dan S. |
|
|
|
Topic Options|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0.270 seconds.