[Mono-devel-list] Mono executes Stored Procedures very slowly

[Atsushi Eno]

Hi,

No, at least it is related. If a DataView is opened, it registers
an event which "updates its indices", to DataTable, and thus then
every time a DataRow is added to the table, DataView runs
UpdateIndex() which causes significant performance loss (depends
on the number of the returned rows though).

In short, DataTable.Rows.Add() was so slow because of DefaultView.

Atsushi Eno

Neumann Péter wrote:
> Hi,
> 
>   I see. But I think, if I am right, that there's nothing to do with
>   my problem, at best I can hope for a patch or a new version. Am I
>   right?
> 
> Bye,
> Peter Neumann
> 
> Thursday, January 27, 2005, 2:32:06 PM, you wrote:
> 
> 
>>Hi,
> 
> 
>>>  Atsushi, could You explain me this hack You did cause I don't
>>>  understand it? (quick hack to svn HEAD???) Sorry for being so
>>>  uncomprehending! :)
> 
> 
>>Just a tiny fix - our DataView is currently so slow and
>>DataTable.DefaultView was always created. So I just changed DataTable
>>to create DefaultView only once when referenced. It is r39621:
>>http://lists.ximian.com/archives/public/mono-patches/2005-January/053633.html
> 
> 
>>Atsushi Eno
>>_______________________________________________
>>Mono-devel-list mailing list
>>Mono-devel-list at lists.ximian.com
>>http://lists.ximian.com/mailman/listinfo/mono-devel-list
> 
> 
> _______________________________________________
> Mono-devel-list mailing list
> Mono-devel-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-devel-list
>