Clive Borrageiro wrote:
Hi,
When I use derby as an embedded database that contains a large amount of
records (in excess of 100,000), the Working set memory (as seen under
Windows Task Manager Mem Usage) of the application's process grows with
time usage.
I created a simple test
Is there a way to retrieve a portion of results using Derby? For
example, I want to get rows from 10 to 20 from a resultset. All dbs I
know of, have this feature, smth like LIMIT n, m , or ROWS n TO m.
Also is there a way to retrieve the total number of rows in last
select?
Thank you.
This question has bean asked several times already . . . Once by me ;-)
The answer is NO. There is no way to retrieve rows in this fashion. I
had to create an extra index column in my table in order to simulate
this kind of behavior. Big pain in the . . .
-Original Message-
From:
Hmmm...
I realize its been a while since I've read Derby's manual, but doesn't Derby
support Scrollable cursors?
A scrollable cursor will allow you to run a query and to fetch specific rows
from the result set. At a minimum, that is what Sergey is originally asking
and which is supported by
Using a scrollable cursor is a possibility. However, you incur a
performance penalty, which in my experience, is quite severe if your
result set is very large. Let's say you need to move the cursor to the
last row in the result set. Derby will iterate through all the rows in
the result set
Timothy Luksha (RIT Student [EMAIL PROTECTED] writes:
On 8/7/06, Marc Schlegel [EMAIL PROTECTED] wrote:
Hi.
I've posted a mail some weeks ago and received some help but I'm still
not able to run Derby on a PocketPC.
So I thought that I should start from scratsch. I'm working with
I see this question all the time... and although I wish that we could
just get a LIMIT command. The answer is simple, when you do your query
only fetch the primary key and use a Scrollable cursor. Since there is
only one column in each row the performance penalty is small. Then you
get the
Hi, guys.
I already responded to this kind of thread some times... You could
search archives, you will find lots of messages (from others too).
But lets go:
If you are using Object persistence, please take a look at:
Is it possible to
set Derby to do case-insensitive searches? The default seems to be
case-sensitive. This would be fine as a global setting that never needs to
change.
thanks,
Terry
Terry Kilshaw wrote:
Is it possible to set Derby to do case-insensitive searches? The default
seems to be case-sensitive. This would be fine as a global setting that
never needs to change.
Hi Terry,
Could give us some more information on what kind of searches you are
talking about? Most
Terry, Is it possible to set Derby to do case-insensitive searches? The default seems to be case-sensitive. This would be fine as a global setting that never needs to change. Are you using 'starts with', 'contains' or 'equals'? These operators tend to be case sensitive. Can you use 'like'?
Stephen Caine wrote:
Terry,
Is it possible to set Derby to do case-insensitive searches? The
default seems to be case-sensitive. This would be fine as a global
setting that never needs to change.
Are you using 'starts with', 'contains' or 'equals'? These operators
tend to be case
On Aug 9, 2006, at 4:27 PM, Farukh S. Najmi wrote:
Stephen Caine wrote:
Terry,
Is it possible to set Derby to do case-insensitive searches? The
default seems to be case-sensitive. This would be fine as a
global setting that never needs to change.
Are you using 'starts with',
13 matches
Mail list logo