Michael Segel wrote:
On Wednesday 05 April 2006 2:16 pm, Daniel John Debrunner wrote:
Michael Segel wrote:
On Wednesday 05 April 2006 12:33 pm, Daniel John Debrunner wrote:
Michael Segel wrote:
On Tuesday 04 April 2006 6:23 pm, Daniel John Debrunner wrote:
Michael Segel wrote:
> On Wednesday 05 April 2006 2:16 pm, Daniel John Debrunner wrote:
>
>>Michael Segel wrote:
>>>Again looking at the code :
>>>
>>>String s1 = "SELECT * FROM employee WHERE emp_id = "+empID+";";
>>>String s2 = "SELECT * FROM employee WHERE emp_id = ?";
>>>
>>>Now in both stat
On Wednesday 05 April 2006 2:16 pm, Daniel John Debrunner wrote:
> Michael Segel wrote:
> > On Wednesday 05 April 2006 12:33 pm, Daniel John Debrunner wrote:
> >>Michael Segel wrote:
> >>>On Tuesday 04 April 2006 6:23 pm, Daniel John Debrunner wrote:
> Daniel John Debrunner wrote:
> >May I
Michael Segel wrote:
> On Wednesday 05 April 2006 12:33 pm, Daniel John Debrunner wrote:
>
>>Michael Segel wrote:
>>
>>>On Tuesday 04 April 2006 6:23 pm, Daniel John Debrunner wrote:
>>>
Daniel John Debrunner wrote:
>May I suggest that if you are writing samples for others to use tha
On Wednesday 05 April 2006 12:33 pm, Daniel John Debrunner wrote:
> Michael Segel wrote:
> > On Tuesday 04 April 2006 6:23 pm, Daniel John Debrunner wrote:
> >>Daniel John Debrunner wrote:
> >>>May I suggest that if you are writing samples for others to use that you
> >>>demonstrate use of paramete
Michael Segel wrote:
> On Tuesday 04 April 2006 6:23 pm, Daniel John Debrunner wrote:
>
>>Daniel John Debrunner wrote:
>>
>>>May I suggest that if you are writing samples for others to use that you
>>>demonstrate use of parameter markers in PreparedStatements. This will
>>>perfom better on Derby
[SNIP]
I could be wrong, and please correct me if I am... But
I thought a PreparedStatement just precompiled the
statement on the database when the statement is
prepared. How is that any more overhead than just
using a normal Statement? When you use a normal
statement and you execute the stateme
On Tuesday 04 April 2006 6:23 pm, Daniel John Debrunner wrote:
> Daniel John Debrunner wrote:
> > May I suggest that if you are writing samples for others to use that you
> > demonstrate use of parameter markers in PreparedStatements. This will
> > perfom better on Derby and all other relational da