I personally like the library list approach. I think that is a very
powerful part of the i5/OS is the library list. There have been MANY
times where I have had to edit loads of SQL because of a schema
(library) change.
--
James R. Perkins



On Thu, Feb 4, 2010 at 14:25, Ashish Kulkarni
<ashish.kulkarni13@xxxxxxxxx> wrote:
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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.