Op Tue, 17 Jul 2007, schreef Coco Pascal:
> Joost van der Sluis wrote:
> > Discussion: What tests could I do more? Is there something I overlooked?
> >
> >
> To me it seems that benchmark tests on 100000 records are missing relevance
> more and more.
> I'm interested in responsiveness in n-tier solutions: opening connection -
> begin transaction - quering/updating mostly 1 or a few records - commit
> transaction - close connection - browsing a small (<50) set of records .
> Opening /closing connections could be skipped in this context when a
> connectionpool is used. Also I'm interested in tests
> selecting/updating/browsing sets larger than 1 million records, obviously
> local.
> Consequently one could ask if one type of dataset could satisfy requirements
> regarding performance and use of resources in both cases.
While relevant for many software, connect and disconnet are largely
uninterresting, as opening a connection per query scales very bad.
Properly designed software uses connection pooling; representative
benchmarks should assume well designed software.
Daniël
_______________________________________________
fpc-pascal maillist - fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal