Re: [gentle-devel] Poor performnace on GetCollection() ?

[Morten M. <mo...@me...>]

Hi Andreas,

>i'm working on a demo program for gentle. The first thing i tried is to
>get a collection of records and display it in a DataGrid for overview.
>To fill the grid iuse ObjectFactory.GetCollection(). I am sared about
>the poor performance of this method. I use the Northwind's customer
>table on an SqlServer 2000 for testing. To read the 91 records in an
>ArrayList it takes around 8 to 12 seconds. Is this really the GetCollection()
>or is my SqlServer installation of poor performance ?. If it is the method,
>is there any faster way to fill a collection ? I have tried GentleList too but
>because of the lazy loading it will not work with a DataGrid control.
>  
>
I'll try to squeeze in a few performance tests this weekend. I've got 
access to a copy of AQTime, which should also be able to highlight 
possible bottlenecks or hot-spots in the code.

Unless your computer is very old I'd expect queries (incl. ones 
retrieving lists of objects) should take less than a second to execute 
(and possibly much less). I can run the entire test suite of >90 tests 
in less than your 8 seconds, and that includes lots of round-trips to 
the database, so something is definately not right :)

Yours,
Morten