{quote}
Don't get overexcited\\
m4tub
{quote}

Damn...ok! 

{quote}
As you can see the test from B was reduced to less than 1/3 of the original value.\\m4ktub
{quote}

First conclusion of the night: database optimizations __do__ work. :-P

{quote}
The E test was a query like  (...)
As an additional note I've found that, in F, most of the time was spent comparing dates (creating a calendar, seting the date and using compareTo()).\\
m4ktub
{quote}

Not that I'm being stuborn or any sort of evangelist but, such results might be due to the lack of optimization in the in-memory search code. There can be better search strategies rather then going from the all list and using compareTo(). Still, on that test the query kicked asses.

{quote}
The last group of tests paging. In-memory paging, that is H, includes creating a new List from the list of persisted objects, sorting that list and geting the subpage (subList(start, start+offset)).\\
m4ktub
{quote}

Too bad you have to do a copy...otherwise it would be smoking fast. You're making the copy because you're ordering the list, right?

{quote}
So, in-memory computation can beat the db in some situations. We lack the kind of infrastructure the database has when regarding query optimization, indexes, cuts, etc. That infrastructure could be partially implemented in a framework to optimize the selection of objects in memory\\
m4ktub
{quote}

So mainly what you are suggesting, is to bring a DB engine into our application?  
I'm not very sure about that, database engines are fine tuned and mature piece of software, a new framework would ~~probably~~ need a huge effort to achieve similar ideas. I say probably because I have no expertises in the area and it's just my common sense. Hence, I think we should leave database related subjects within the database. 

{quote}
:-) Guess this didn't gave us THE answer to our problems but at least we have some "pretty" graphics. Uh! Shinnny!!!.\\
m4ktub
{quote}

Well there's no "THE" answer, but indeed we have some "Uh! Shinnny!!!" layout breaking - if I may add - graphics. Now for real, they may not give the ultimate answers, but still they give us a good insight.

Now let's wait for João's feedback saying "AH! I told you" ~~laugh~~