Re: Java and Relations DBs..

[Dieter.Bender@xxxxxxxxxxx (Dieter Bender)]

Hi,

it depends on...
column functions tend to lock the whole table, depending on your commit lock
level. and this can't be fast.

Dieter


Am Mittwoch, 9. Januar 2002 19:34 schrieben Sie:
> > Yes, I could do that, but that is essentially what that
> > loadByCustomerNumber(customerNumber) method is doing.
>
> Is it really?
>
> The count function is built in to SQL, so it *PROBABLY* can do the count a
> lot faster than your load customers method.  I suspect it would operate
> without ever touching the data (unless it had to) ... with the appropriate
> views available, it could probably just indexes.
>
> david
> _______________________________________________
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
> mailing list To post a message email: JAVA400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> or email: JAVA400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.

--
mfG

Dieter Bender


DV-Beratung Dieter Bender
Wetzlarerstr. 25
35435 Wettenberg
Tel. +49 641 9805855
Fax +49 641 9805856
www.bender-dv.de