I am making many calls to the database to lookup various account balances.

For example, to get cash balances I am using (with ADO call):

vSQL = "sp_report TrialBalance show sum(Debit)+sum(Credit) as Cash parameters DateTo = " _
& "{d'" & Format(AsOfDate, "yyyy-mm-dd") & "'}" & ", accountfiltertype = 'Bank'"

Is the balance sheet faster?

Is looking for the total line or label faster?

Is there a particular table I can add up records from/through that would be faster than calling a report?  (The table called transaction does not appear to be available to me in the U.S. version.)

Thank you.

You must have an old pre-2005 copy of QuickBooks as the transaction table appeared from QuickBooks 2005 onwards in USA and 2008 for the rest of the world. 

I've covered this pretty much in How do I run a Trial Balance Report?  and How can I query the audit trails? 

Thanks for info on Transaction table.  I was testing in an old version, but using most current version in production, so I will check this out.

My question for you was which method of getting an account balance as of a certain date is fastest?

I'm getting ready to start a project where I have to make a lot of SQL Select calls to QODBC using ADO and I'm trying to figure out which is the fastest method.

Should I add up transactions or use the trial balance SP or use the balance sheet or some other report?

Thank you