See Thread at: http://www.techienuggets.com/Detail?tx=65388 Posted on behalf of
a User
Hi all,
I am working on developing a web application where:
first, a script will retrieve data from the Japplet then validate it with
information on Database (Apache derby database)
then, it will sent an Ok
Hi all,
I am new to Derby and database programming in general. This is my first
real-world setup, and I am getting horrifying performance from my application.
(The code is available at http://code.google.com/p/jamun/ )
It is one particular query that is causing me major worry. It is a simple
Harshad wrote:
These seem to have paid off; the actual query time
(statement.executeQuery) is pretty fast : about 1 or 2 milliseconds.
But reading from the resultSet using APIs such as getString, getLong,
takes about 250 ms or more!!
Forgot to mention; the query usually (99%) results in
Harshad wrote:
Harshad wrote:
These seem to have paid off; the actual query time
(statement.executeQuery) is pretty fast : about 1 or 2 milliseconds.
But reading from the resultSet using APIs such as getString, getLong,
takes about 250 ms or more!!
Forgot to mention; the query usually (99%)
Harshad wrote:
Harshad wrote:
These seem to have paid off; the actual query time
(statement.executeQuery) is pretty fast : about 1 or 2 milliseconds.
But reading from the resultSet using APIs such as getString, getLong,
takes about 250 ms or more!!
Forgot to mention; the query
Hi Emmanuel,
Emmanuel Cecchet wrote:
Are you using getString(columnName) or getString(1) to access the
result? Some databases only fetch ResultSetMetaData (including column
names) when it needs them. Using the column index can dramatically improve
performance. I am not sure if this is the
Hi Kristian,
The entire code is available at http://code.google.com/p/jamun/.
It is written in scala, which might not be familiar to all. I am posting below
some snippets that might help.
Kristian Waagan wrote:
I think you'll have a better chance of getting any answers if you
provide more
Harshad wrote:
select name,version,release,time from PKG where PKG.id in (select id from
PROVIDES where name = ?),
What happens if you run this statement instead:
select pkg.name,pkg.version,pkg.release,pkg.time from pkg, provides
where pkg.id = provides.id and provides.name = ?
Bryan Pendleton wrote:
Harshad wrote:
select name,version,release,time from PKG where PKG.id in (select id
from PROVIDES where name = ?),
What happens if you run this statement instead:
select pkg.name,pkg.version,pkg.release,pkg.time from pkg, provides
where pkg.id =
Harshad wrote:
Bryan Pendleton wrote:
Harshad wrote:
select name,version,release,time from PKG where PKG.id in (select id
from PROVIDES where name = ?),
What happens if you run this statement instead:
select pkg.name,pkg.version,pkg.release,pkg.time from pkg, provides
teamderby wrote:
Hi Stephan,
Excellent, it worked!
i'm extremely grateful, you've ended a lot of frustration on my part and i
cannot thankyou enough for the help you've supplied.
the tutorial is excellently produced and i am sure will be a welcome
resource for other people attempting to set
11 matches
Mail list logo
