Welcome Visitor, Please Login or Register Now Saturday, April 27, 2024 06:31 PM 
Forums Index > Mewsoft Products > Auctionawy > Auction Pruning
New Topic   New Reply
Search for:
Author Message
wannauseit wannauseit's personal page
Registered Member
Posts: Display member's posts
Joined: 04-27-24 06:31 PM
Member Offline
View Member's Profile PM
 
Back to top
Auction Pruning Edit Delete Reply with quote Quote
First Post Posted on: 10-26-08 04:09 AM next post first post
When pruning auctions, why is the Items table left "overhead"?\ \ Also, pruning auctions for X-number of days only deletes auctions that have closed... Correct?
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 04-27-24 06:31 PM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: Auction Pruning Edit Delete Reply with quote Quote
Reply #: 1 Posted on: 10-26-08 07:21 AM next post previous post

Your first questions not understood.

Yes for the second question, only closed auctions can be pruned.


Mewsoft Support
www.mewsoft.com
wannauseit wannauseit's personal page
Registered Member
Posts: Display member's posts
Joined: 04-27-24 06:31 PM
Member Offline
View Member's Profile PM
 
Back to top
Re: Auction Pruning Edit Delete Reply with quote Quote
Reply #: 2 Posted on: 10-26-08 03:30 PM next post previous post
When I pruned my auctions, it deleted about 45 auctions.\ \ When I checked the database tables in phpMyAdmin, the Items table was 66,000 KB overhead.\ \ Is this something we need to monitor everytime we prune auctions so we can optimize the tables to get rid of the overhead?
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 04-27-24 06:31 PM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: Auction Pruning Edit Delete Reply with quote Quote
Reply #: 3 Posted on: 10-27-08 01:44 PM last post previous post
This is handeld automaticalley by the MySQL server, you do not need to optimize it manually but no problem if you did.

Mewsoft Support
www.mewsoft.com
Page 1 of 1
Go to page:

New Topic   New Reply Mark Unread
Jump to:  
Delete   Move     Lock   +Favorits   +Notify   Print  

  Mewsoft and Mewsoft Logos are registered trademarks. ® Corporation. All Rights Reserved.  Copyright -  Privacy -  Terms of Use  Page Load: 0.1038 Seconds 
Powered by Boardawy © 2000-2011. Mewsoft Corporation