RE: Best way to code SQL query in web application

["Dan Kimmel" <dkimmel@xxxxxxxxxxxxxxx>]

I doubt you'll ever discern any difference; I've not noticed any.

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Ashish Kulkarni
Sent: Thursday, February 04, 2010 4:25 PM
To: Java Programming on and around the iSeries / AS400
Subject: Best way to code SQL query in web application

I have a question about writing SQL query in web application, Which of
the following is more efficient and why

select  col1, col2, col3 from myschema.mytable;

where i can specify myschema in a properties file and use it in my
application or hard code it

OR


select  col1, col2, col3 from mytable;

and set my JDBC connection with correct library list so it will resolve
where the table is at run time.

I would like to know in respect to performance, would letting connection
know the schema will be faster or making it search in library list will
be fater

Any ideas

--
Ashish
www.ayurwellness.com
www.mysoftwareneeds.com
--
This is the Java Programming on and around the iSeries / AS400
(JAVA400-L) mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/java400-l.