ProductCart E-Commerce Solutions Homepage
Forum Home Forum Home > ProductCart Add-on's > QuickBooks Add-on
  New Posts New Posts RSS Feed - Various Tables Growing
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Various Tables Growing

 Post Reply Post Reply
Author
Message
odathp View Drop Down
Newbie
Newbie


Joined: 19-April-2010
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote odathp Quote  Post ReplyReply Direct Link To This Post Topic: Various Tables Growing
    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
Back to Top
Greg Dinger View Drop Down
Certified ProductCart Developers
Certified ProductCart Developers
Avatar

Joined: 23-September-2006
Location: United States
Status: Offline
Points: 238
Post Options Post Options   Thanks (0) Thanks(0)   Quote Greg Dinger Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
odathp View Drop Down
Newbie
Newbie


Joined: 19-April-2010
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote odathp Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
Matt View Drop Down
Moderator Group
Moderator Group


Joined: 20-July-2006
Location: United States
Status: Offline
Points: 73
Post Options Post Options   Thanks (0) Thanks(0)   Quote Matt Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
Greg Dinger View Drop Down
Certified ProductCart Developers
Certified ProductCart Developers
Avatar

Joined: 23-September-2006
Location: United States
Status: Offline
Points: 238
Post Options Post Options   Thanks (0) Thanks(0)   Quote Greg Dinger Quote  Post ReplyReply Direct Link To This Post 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?
Back to Top
Matt View Drop Down
Moderator Group
Moderator Group


Joined: 20-July-2006
Location: United States
Status: Offline
Points: 73
Post Options Post Options   Thanks (0) Thanks(0)   Quote Matt Quote  Post ReplyReply Direct Link To This Post 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.  
Back to Top
Greg Dinger View Drop Down
Certified ProductCart Developers
Certified ProductCart Developers
Avatar

Joined: 23-September-2006
Location: United States
Status: Offline
Points: 238
Post Options Post Options   Thanks (0) Thanks(0)   Quote Greg Dinger Quote  Post ReplyReply Direct Link To This Post 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. 
Back to Top
odathp View Drop Down
Newbie
Newbie


Joined: 19-April-2010
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote odathp Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.059 seconds.