reply to thender
Re: Networking quickbooks - network quality. Stupid question #1
Have you verified that ALL of your client machines are now syncing at gigEe speeds? (I skimmed but did not see this being emphatically stated.)
#2 - For your server -Are you using the on board ethernet port and have you confirmed that is syncing at gige? (Again I skimmed but did not see that was specifcially stated as having been checked.)
I don't see any point to using anything but the onboard nic unless you are using a 4x or faster pcie nic.
Stupid q's #3- have you checked to see how much actual data is being transferred when you launch a query? Traffic shaping (how much, how fast, and when) for the query might give a clue as to where the bottleneck is.
I forgot to mention from what you describe I suspect the bottleneck is quickbooks and there is nothing more you can do to improve performance as long as everything is connected at gig-e speeds.
I do work in a large database all day long for customer care. We have 100,000 customers with each customer having an average of 20 tickets and 10 products. Customer lookup is instantaneous and the server is a SINGLE core pentium 4 xeon (2.8ghz), 4 gig ram, with a 5 disk raid 5 array (scsi). The only time I wish for more performance is if I'm doing a search for open tickets which can take up to 10 minutes looking over the past 2 years. I would definitely say QB is a pig.