db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Vatter <thomas.vat...@network-inventory.de>
Subject Re: order by
Date Thu, 02 Mar 2006 11:00:36 GMT
Kristian Waagan <Kristian.Waagan@...> writes:


Hello Kristian,

I'm doing this on a Windows XP system, I start all java processes with 
-Xmx1024m, I had a try with 2048 but the process did not start so I stayed 
with 1024. "Between 912 and 960" is the total usage for the machine, 
read from the task-manager. I have thought about it, derbys pageSize 
is 4k, I have increased pageCacheSize from 1.000 to 10.000, resulting 
in 40mb steps, this would explain that memory "ends" before 1024 is 
reached. Yes, I was unprecise for shortness with the word "record". 
I should have said "record in the main database table" or "dataset".
But you are right, a dataset (or line) in my spreadsheet has around 
30 fields only. I had the network server running on the described machine, 
because I am testing how derby performes in the network situation, 
because in the single user situation I have typically less data.


View raw message