Hi Umberto,

I'm running a similar setup (Redhat Linux 8, JVM 1.4.1, Tomcat 4.1.27, 512
meg RAM on a 3.06 Ghz Pentium 4 box).

I'm running JayBird 1.0.1, though, and instead of running JSTL I'm using
DBCP for connection pooling of DataSources and making calls to the
DataSource in the JSP.

My web app returns 10 records of about 100 characters each in less than 4
seconds on the first search, and in less than 1 second on subsequent
searches (connection is pooled, so it doesn't have to set it up again).

I'm not sure if JSTL pools connections, but since it worked OK with
Interclient that's not the problem. If you aren't connection pooling, it
can help a lot with performance.

Can you drop back to 1.0.1? I suspect the transaction stuff you need is
supported there as well as in 1.5. In fact if Interclient worked (sort of)
I'm sure JayBird 1.0.1 will.

Looking at the JSTL specs for transactions below, I believe JayBird supports
setting the isolation levels listed:
<sql:transaction [dataSource="dataSource"]

[isolation=isolationLevel]>

<sql:query> and <sql:update> statements

</sql:transaction>

isolationLevel ::= "read_committed"

| "read_uncommitted"

| "repeatable_read"

| "serializable"


I can send you an up-to-date copy of the jars from the current cvs if you
would like. I'll upload a newer snapshot to the Yahoo site as well.

Rick

----- Original Message -----

> Hi Rick,
> comments inline.
>
> --- In Firebird-Java@yahoogroups.com, "Rick Fincher" <rnf@t...> wrote:
snip ...
>
> That I understand it, but the big trouble is that my app (which uses
> transactions and transactions are the reason that forced me to upgrade
> the driver to jaybird 1.5) might be transferring about 20 bytes for
> each query for that is definitely not the problem. Also I didn't see
> any big memory load on the application server.
>
snip...
> >
> > Here are a few questions that may help us help you:
> >
> > What kind of app server are you running? (Tomcat, JBoss, ?).
> > What version of JayBird are you running?
> > What OS is the server running on?
> >
>
> I am runnign tomcat 4.1.27 on a HP netserver 800 with 1.3GB of RAM
> with SUSE Linux 8.0 and j2sdk 1.4.x. The vary same web now has been
> ported to oracle and the performance gap I see is unsettling!
>
> I use JSP with JSTL 1.0.4 grabbed from jakarta.apache.org.
> The db is on another Netserver, running the same linux on a 100MB
> fully switched lan.
>
> IBCONSOLE or Interclient do not show this behavior and are reasonably
> fast. Only transactions appear not to commit consistently and THAT is
> a problem :-) !
>
> Thanks for any help,
> Umberto
>
> > Hope this helps,
> >
> > Rick
> >
> > ----- Original Message -----
> >
> > > Hi all, I have been lurking on this ml for some time, but I think
> > > nobody has ever mentioned how to use the jdbc type 2 driver.
> > > Is there any hope that this driver would perform substantially better
> > > than the type 4 driver? I am running a web application that was
> > > recently migrated from interclient to jaybird, but performance dropped
> > > to almost unacceptable level.
> > >
> > > If you could provide any pointers, that would be very much
> appreciated.
> > > Umberto
> > >
>
>
>
>
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/Firebird-Java/
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to:
> http://docs.yahoo.com/info/terms/
>
>