nrtb-core team mailing list archive

Thread
Date

[Question #146869]: Should we prefer discrete method calls or selector parameters?

To: nrtb-core@xxxxxxxxxxxxxxxxxxx
From: Rick Stovall <question146869@xxxxxxxxxxxxxxxxxxxxx>
Date: Fri, 25 Feb 2011 17:00:43 -0000
Reply-to: question146869@xxxxxxxxxxxxxxxxxxxxx
Sender: bounces@xxxxxxxxxxxxx

New question #146869 on New Real Time Battle:
https://answers.launchpad.net/nrtb/+question/146869

In dbAccess, there is a int dbAccess::sqlExecute (int type, string scrpt) method. The two arguments are the query type (insert, select, update, etc.) and the query itself. My question is should be forcing a scan of a select table on every query, or would  both the code and the interface be improved by using distinct methods for each? 

In other words, I believe it would may be better to provide distinct dbAccess methods for insert, update, exec and select; This is no more complex to use than using an enumerated query type selector and has the additional advantage of removing the select statement, improving performance on what are going to be very frequently called methods.

George, I am particularly looking for your opinions on this, although all members of ntrb-core are welcome to pipe in. This certainly will not be the last question of it's type we see!

-- 
You received this question notification because you are a member of NRTB
Core, which is an answer contact for New Real Time Battle.