Results 1 to 8 of 8
  1. #1

    Default Deleting Really Old Customers, Orders, etc

    Is there a way to delete old info that is just clogging up the database and bogging things down? Like deleting customers, orders, banner history, etc to a certain date so that really old stuff can be gone? I have had my store for 5 or so years now and some things that are useless are just sitting there. Any tool for clearing out dross? Something that doesn't mess with products, categories, meta tags, etc. Thanks!

  2. #2
    Join Date
    Aug 2009
    Posts
    6
    Plugin Contributions
    0

    Default Re: Deleting Really Old Customers, Orders, etc

    I asked a similar question with no response. Doesn't anyone have a solution to this?

  3. #3

    Default Re: Deleting Really Old Customers, Orders, etc

    In my investigation of this with my host, they've told me the best thing to do is repair and analyze the database and then manually delete stuff. They feel it's just too dangerous to have an automated way to do it. I think it would be ok, as long as only certain tables were cleaned up. But, what do I know?

  4. #4
    Join Date
    Jan 2010
    Posts
    189
    Plugin Contributions
    1

    Default Re: Deleting Really Old Customers, Orders, etc

    You could use Apsona ShopAdmin for this purpose. You can locate old customers or orders via its search feature (e.g., create a search term such as 'created date older than Jan 1, 2006') and then click Tools - delete all.

    Hope this helps.

    Apsona
    http://apsona.com

  5. #5
    Join Date
    Jan 2007
    Location
    Australia
    Posts
    6,166
    Plugin Contributions
    7

    Default Re: Deleting Really Old Customers, Orders, etc

    Quote Originally Posted by Doodlebuckets View Post
    Is there a way to delete old info that is just clogging up the database and bogging things down? Like deleting customers, orders, banner history, etc to a certain date so that really old stuff can be gone?
    Not that I'm aware off. Besides, what makes you think that this information is affecting the performance of your store? Unless there is something amiss with the database itself it wouldn't matter how much 'old stuff' you delete it won't make any noticeable difference to the performance of the site. Database queries are lightning fast compared to the time it takes to render (display) a page.

    Also, it is bad practice to delete old records from a database. It is better/safer to mark them 'inactive' (where the need and possibility exists).

    Anyway, if I knew of a reliable way of doing this I'd certainly be telling you about it, but if such code or module doesn't exist at least you'll have an idea why (not a high demand for it).

    Cheers
    Rod
    Ozpost - The Ultimate Shipping module for Australian Merchants. Click these links for its Homepage, or Download from Zen-Cart.com.

  6. #6

    Default Re: Deleting Really Old Customers, Orders, etc

    Quote Originally Posted by RodG View Post
    Not that I'm aware off. Besides, what makes you think that this information is affecting the performance of your store? Unless there is something amiss with the database itself it wouldn't matter how much 'old stuff' you delete it won't make any noticeable difference to the performance of the site. Database queries are lightning fast compared to the time it takes to render (display) a page.

    Also, it is bad practice to delete old records from a database. It is better/safer to mark them 'inactive' (where the need and possibility exists).

    Anyway, if I knew of a reliable way of doing this I'd certainly be telling you about it, but if such code or module doesn't exist at least you'll have an idea why (not a high demand for it).

    Cheers
    Rod
    My host tells me so. I have had my store for 5yrs or so and my admin activity table and others were massive and were bogging down my store. I had not realized that I needed to sort of "defrag" my tables periodically by doing the repair and analyze functions. I had a lot of "Overhead" in my tables too, which I didn't know was a problem. Emptying my admin activity and banner history helped a lot.

  7. #7
    Join Date
    Aug 2009
    Posts
    6
    Plugin Contributions
    0

    Default Re: Deleting Really Old Customers, Orders, etc

    My client needs the customers and order removed because we are moving the store and only need products. How can we make this happen?

  8. #8
    Join Date
    Jan 2007
    Location
    Australia
    Posts
    6,166
    Plugin Contributions
    7

    Default Re: Deleting Really Old Customers, Orders, etc

    Quote Originally Posted by Doodlebuckets View Post
    My host tells me so.
    Unless your host 'snoops' on your site/database they wouldn't have a clue how many 'old' customer records you have.

    Quote Originally Posted by Doodlebuckets View Post
    I have had my store for 5yrs or so
    Databases don't get sluggish due to age.

    Quote Originally Posted by Doodlebuckets View Post
    and my admin activity table and others were massive and were bogging down my store.
    They may be massive, but you are still making an assumption about it being the cause of 'bogging down the store'.

    Quote Originally Posted by Doodlebuckets View Post
    I had not realized that I needed to sort of "defrag" my tables periodically
    Database tables don't need a 'defrag'. Admittedly there is an option to 'optimize' a database (which basically clears out any 'spaces' caused by record deletions) but this should only be used on tables that regularly have records deleted (such as log files). Other records (such as customer sales data, etc) really should never be deleted from a database (as previously mentioned), so performing an 'optimize' on these tables is effectively a waste of time.

    Quote Originally Posted by Doodlebuckets View Post
    by doing the repair and analyze functions. I had a lot of "Overhead" in my tables too, which I didn't know was a problem..
    Repair and analyze will make good most errors and problems caused by a server falure or similar... over 5 years there have probably been lots of these (although MySQL does attempt an auto-repair if it detects a problem when it restarts). It pays to keep an eye on this, but generally it takes care of itself.

    Quote Originally Posted by Doodlebuckets View Post
    Emptying my admin activity and banner history helped a lot.
    I'm happy that you believe this to be true, but neither of these will have any affect whatsoever on the performance of your store.

    I suspect that what would have made a difference would have been the repair on the tables, as a corrupt table can really slow things down.

    Please understand that I'm not giving you all these details to show how smart I am or to criticize you in any way, I am merely trying to stress the fact that what you *think* is bogging things down probably isn't the case, and that you can get, and maintain peak performance just by running the repair/optimize tools without having to delete/purge 5 year old sales and customer data. This kind of data can be priceless and probably irreplaceable, it could be a shame to toss it away based on a misconception. (I actually have sales and repair data going back over 20years).

    Having said that, it is YOUR store, and YOUR data... I am just expressing a concerned opinion.

    Cheers
    Rod
    Last edited by RodG; 21 May 2010 at 04:07 PM.
    Ozpost - The Ultimate Shipping module for Australian Merchants. Click these links for its Homepage, or Download from Zen-Cart.com.

 

 

Similar Threads

  1. v139h Deleting old order records and customers
    By devus in forum General Questions
    Replies: 4
    Last Post: 21 Dec 2012, 09:50 AM
  2. Mass deleting customers & orders from a test database
    By KevinP in forum General Questions
    Replies: 4
    Last Post: 25 May 2009, 03:40 PM
  3. Deleting all customers/orders
    By mooncavecrystals in forum General Questions
    Replies: 4
    Last Post: 23 Apr 2008, 01:46 AM
  4. Deleting Customers & Orders
    By esugrue in forum Managing Customers and Orders
    Replies: 2
    Last Post: 5 Nov 2007, 11:17 AM
  5. error when deleting old customers
    By godin5150 in forum General Questions
    Replies: 1
    Last Post: 30 Sep 2007, 03:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR