ProductCart Shopping Cart Software Forums : Various Tables Growing https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 10 Apr 2026 12:48:38 +0000 Sun, 04 Sep 2011 13:42:30 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=4709 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Various Tables Growing : Thanks everyone for the valued...]]> https://forum.productcart.com/various-tables-growing_topic4709_post18235.html#18235 Author: odathp
Subject: 4709
Posted: 04-September-2011 at 1:42pm

Thanks everyone for the valued input.  The database was well over 500MB.  It is now down to 40MB after purging all of the aforementioned tables.

FYI.  This customer synchronizes every 5 minutes 24/7.  I've recommended they synchronize manually as needed, but they keep going back to the auto synchronize (which is indeed an option).

The only reason this surfaced is we just moved their site from a dedicated server to a shared host.

Thanks again,
Jack
]]> Sun, 04 Sep 2011 13:42:30 +0000 https://forum.productcart.com/various-tables-growing_topic4709_post18235.html#18235 <![CDATA[Various Tables Growing : Thanks Matt. I only wanted to...]]> https://forum.productcart.com/various-tables-growing_topic4709_post18234.html#18234 Author: Greg Dinger
Subject: 4709
Posted: 04-September-2011 at 1:18pm

Thanks Matt.  I only wanted to clarify since there has been a ticket with BHO and their developer, and questions as to whether our practice of clearing those tables was having the side-effects that were the subject of that ticket.  Appreciate it.  ]]> Sun, 04 Sep 2011 13:18:28 +0000 https://forum.productcart.com/various-tables-growing_topic4709_post18234.html#18234 <![CDATA[Various Tables Growing : Sure, I didn&#039;t mention those...]]> https://forum.productcart.com/various-tables-growing_topic4709_post18233.html#18233 Author: Matt
Subject: 4709
Posted: 04-September-2011 at 1:11pm

Sure, I didn't mention those because we talked about them offline.  For everyone else watching, those can also be cleared.  ]]> Sun, 04 Sep 2011 13:11:54 +0000 https://forum.productcart.com/various-tables-growing_topic4709_post18233.html#18233 <![CDATA[Various Tables Growing : Thanks Matt - what about pcQB_Queue...]]> https://forum.productcart.com/various-tables-growing_topic4709_post18231.html#18231 Author: Greg Dinger
Subject: 4709
Posted: 04-September-2011 at 12:56pm

Thanks Matt - what about pcQB_Queue and pcQB_History?
 
You directed us to clear those tables in site that I mentioned to you off-forum.  Are we still ok to clear those tables?
]]> Sun, 04 Sep 2011 12:56:47 +0000 https://forum.productcart.com/various-tables-growing_topic4709_post18231.html#18231 <![CDATA[Various Tables Growing : You can purge pcQB_Hosts and pcQB_CompanySessions.I...]]> https://forum.productcart.com/various-tables-growing_topic4709_post18230.html#18230 Author: Matt
Subject: 4709
Posted: 04-September-2011 at 12:41pm

You can purge pcQB_Hosts and pcQB_CompanySessions.

I want to point out to anyone else reading this that the data saved in these tables is insignificant for an average store.  Over the time period of several years it can build up if you synchronize very frequently.

We will update the "Clean Up" button in the Add-On's main menu to include the two tables above.  That will be in the next release.
]]> Sun, 04 Sep 2011 12:41:46 +0000 https://forum.productcart.com/various-tables-growing_topic4709_post18230.html#18230 <![CDATA[Various Tables Growing : Have you looked at nuking pcQB_Hosts...]]> https://forum.productcart.com/various-tables-growing_topic4709_post18226.html#18226 Author: odathp
Subject: 4709
Posted: 04-September-2011 at 12:51am

Have you looked at nuking pcQB_Hosts and pcQB_CompanySessions?

pcQB_CompanySessions 281,000+ records using 49 MB.

pcQB_Hosts 281,000+ records using 64 MB.

The total database is 154.80MB

These 2 tables account for almost 75% of the database.

And that's after nuking pcQB_Queue and pcQB_History.]]> Sun, 04 Sep 2011 00:51:28 +0000 https://forum.productcart.com/various-tables-growing_topic4709_post18226.html#18226 <![CDATA[Various Tables Growing : I&#039;ve been meaning to confirm...]]> https://forum.productcart.com/various-tables-growing_topic4709_post18225.html#18225 Author: Greg Dinger
Subject: 4709
Posted: 03-September-2011 at 11:46pm

I've been meaning to confirm a related question - perhaps Matt would pop in please.
 
We have a hosting client who runs the QB Synch several times a day.  The result is that these tables accumumlate significant numbers of records.
 
pcQB_Queue
pcQB_History

We have created an admin tool that allows those tables to be cleared on an ad-hoc basis.
 
Question:  we have not yet deployed that tool, pending confirmation that EI is clearly comfortable with those tables being nuked occasionally.  Any problems with that?
 
Once I have an answer to this, if Jack or others need it, I can make it available for a small fee until EI comes up with a built-in solution.
]]> Sat, 03 Sep 2011 23:46:56 +0000 https://forum.productcart.com/various-tables-growing_topic4709_post18225.html#18225 <![CDATA[Various Tables Growing : A client has been successfully...]]> https://forum.productcart.com/various-tables-growing_topic4709_post18224.html#18224 Author: odathp
Subject: 4709
Posted: 03-September-2011 at 11:16pm

A client has been successfully using the Quickbooks Add-on for a year or so.

There are various tables that continue to grow unbridled along with the database size.

Is it safe to empty this table?

pcQB_Hosts = 281,000+ records

I already emptied these tables with no side effects.

pcQB_Queue, pcQB_Sessions, pcQB_History

There doesn't seem to be any logical reason to permanently stored most of this data.

It would be nice to have something in the back end to clean these tables periodically.

Or better yet, something in the code to optimize the tables.

Thanks,
Jack
]]> Sat, 03 Sep 2011 23:16:48 +0000 https://forum.productcart.com/various-tables-growing_topic4709_post18224.html#18224