Hi Roman, it seems that the file size is too big to be sent to mailing
list directory.
I tried to post the file (the file size is 6,5 MB) and it always failed.

Do you have any other idea to send the file to you ?


Regards,
Ferry


--- In Firebird-Java@yahoogroups.com, "ferry_new2004" <ferry2004@...>
wrote:

>
> Thank you very much Roman.
> In about 15 minutes later, I will put post the TestCase (file name
> TestCase.zip)
> Your idea is very good.
>
> Thank you very much.
>
> Regards,
>
> Ferry
>
> --- In Firebird-Java@yahoogroups.com, Roman Rokytskyy <rrokytskyy@>
> wrote:
> >
> > > The result shows :
> > > delphi based program took 1 minute and 10 seconds to finish while
> > > java based program took 1 minute 35 seconds.
> > >
> > > The number of returning records is about 12000 recods.
> > >
> > > When i noticed the memory usage firebird database only consumed

about

> > > 19000K while Microsoft SQL Server 2000 consumed about 300000K.
> >
> > ...the numbers are from my POV quite low (sure, I did not see your
> > tests)... The memory usage can be configured - the

DefaultDbCachePages

> > parameter, also the SortMemUpperLimit parameter...
> >
> > But without having your tests we cannot tell anything useful at all.
> >
> > Roman
> >
>