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

Atsushi Eno atsushi at ximian.com
Thu Jan 27 09:15:59 EST 2005


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:
>>>  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:
>>Atsushi Eno
>>Mono-devel-list mailing list
>>Mono-devel-list at lists.ximian.com
> _______________________________________________
> Mono-devel-list mailing list
> Mono-devel-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-devel-list

More information about the Mono-devel-list mailing list