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

[Atsushi Eno]

Hi again,

I made a quick hack to svn HEAD. After that... (with reduced rows)

[old one]
$ mono ./perf1.exe
00:00:01.2020000, 12020000

became

[new one]
$ mono ./perf1.exe
00:00:00.0800000, 800000

This performance will hold unless you use DefaultView (our
DataView performance is still cheap.)

Atsushi Eno


Atsushi Eno wrote:
> Hi Péter,
> 
> I created a simple test code (attached) and ran on windows.
> Here's the results:
> 
> $ ./perf1.exe
> 00:00:00.1101584, 1101584
> 
> $ mono ./perf1.exe
> 00:00:22.1210000, 221210000
> 
> So, mono DataTable is _extremely_ slow. This looks the culprit of
> the performance loss.
> 
> Lemme see if I can optimize easy bits.
> 
> Thanks,
> Atsushi Eno