slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Data & Imports Forums - T-SQL & Queries
Forum to discuss general T-SQL questions and help with queries related to SalesLogix data. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to T-SQL & Queries | New Thread

View: Search:

Author

Thread: Purging by Query

Soup Dude
Posts: 20

Purging by Query Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 15 Mar 07 2:46 PM

I am needing to purge data in a particular query. This purge will persist of some 170,000 records (data that has not been modified in over 3 years). Is it possible to purge a specific query? I typically purge on a specific field. Seeming my soon to be purged accounts are already within a query that has been built, would it be easier to purge that group or by specific data field criteria like usual. I currently do not recognize an option to purge by group. v.6.2.6

[Reply][Quote]

Jeff Ballard
Posts: 326

Re: Purging by Query Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 15 Mar 07 5:22 PM

Soup Dude,

First, of course, backup and test on a test database. This is a lot of data we're talking about. That's my disclaimer in case something goes wrong.

In the LAN client, select the group you want to purge. Select Tools-->Maintenance-->Purge Records. If it's an account group, select "Account and Related Records", if it's contact, select "Contact and Related Records", or oppty. if that's the case. Click Next. Select "Entire current lookup or group", again making sure you're on the right group. Click "Finish".

That should take care of it!

Jeff

[Reply][Quote]

Timmus Agersea
Posts: 328

Re: Purging by Query Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 15 Mar 07 7:24 PM

I would break your group into MUCH smaller subsets. My experience is that the process is horribly slow. I suspect that it would take longer than a weekend to purge that much data.

Timmus

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: Purging by Query Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 15 Mar 07 11:28 PM

The built-in purge function completely sucks. I'd be very surprised if it could actually handle that

I'd probably opt to doing something custom, like a DTS package or even a series of SQL statements. Then you'd have no problem defining the criteria as you could just base it off a query.

[Reply][Quote]

Jeff Ballard
Posts: 326

Re: Purging by Query Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 16 Mar 07 10:37 AM

See what happens when I dare to venture outside the world of the web client? I learn something. I'd take Timmus and Ryans suggestions and ignore mine.

I actually think I knew this from years past, but had forgotten it.

< I'm now heading over to the web client forum where I might actually contribute something worthwhile. >

Jeff

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: Purging by Query Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 16 Mar 07 10:58 AM

Quote:

Originally posted by Jeff Ballard

See what happens when I dare to venture outside the world of the web client? I learn something. I'd take Timmus and Ryans suggestions and ignore mine.

I actually think I knew this from years past, but had forgotten it.

< I'm now heading over to the web client forum where I might actually contribute something worthwhile. >

Jeff

Hehe.

Jeff, your answer *is* completely 100% correct. Those are the steps to do it. I'm just not sure the software could handle it. I've always been astonished at how long the purge wizard took to delete records. DELETES! I've never understood that.

-Ryan

[Reply][Quote]

Timmus Agersea
Posts: 328

Re: Purging by Query Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 16 Mar 07 5:30 PM

Yeah, I wasn't busting your chops Jeff.

Just wanted to forewarn about the performance issue.

Timmus

[Reply][Quote]

Jeff Ballard
Posts: 326

Re: Purging by Query Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 16 Mar 07 6:28 PM

I know - your insight is always appreciated!

Jeff

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 5/3/2025 4:55:05 PM