Re: Best way to code SQL query in web application

I expect you will have more significant performance problems, over anything that would arise from this kind of an issue (if there even is one). There is a *ton* of performance tuning that can be done for java web applications on the i.

Opt for the maintainable solution in this case.

Brian

On 04/02/10 2:25 PM, Ashish Kulkarni 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