Which code is better in terms of performance?

Question

would like to know,

is it better to put a connectionstring (called from a static method from another class) into a string variable, and pass the string to the methods, or get the connectionstring (call the static method) in every methods that requires it?


//==================================
//SAMPLE 1
//==================================

public static void Main()
{
string strConn = ConnectionString.GetConnectionString();

AA(strConn);

if (VV())
{
BB(strConn);
}
}


//=================================
//SAMPLE 2
//=================================

public static void Main()
{
Preprocessing();

if (VV())
{
PopulateUIData();
}
}

private static void AA()
{
string strConn = ConnectionString.GetConnectionString();

}

private static void BB()
{
string strConn = ConnectionString.GetConnectionString();

Answer 1

There does not seem to be too great a difference in both codes . Check out Java Documentation on Sun Website to find out if they have mentioned anything on this .

Answer 2

Well it depends if this function or method is going to be used multiple times then I suggest to use option #1 Call the method from another class.

If the call of this method if this is only one time call then go option #2 Call method everytime is required. You can also make use of this method/Class for other program use ...

Good Luck

Answer 3

Actually, it would be better if you keep the connection open and use the pass the connection variable around.