Search:

When you declare all your queries as statics they will of course take up memory like that but you will have a reference to the same strings so it will be dead quick.

When you use the StringBuffer...

I meant you should have a list of queries.



private static final String QUERY1 = "select username,password,email from userstable";
private static final String QUERY2 = "select * from...

Usually you'd have a number of static queries I believe, so if I was you I'd create some static variables holding the constants for your queries.


private static final String SELECT_ALL_USERS =...