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

[Neumann Péter]

Hi Guys,

  Thanks for all Your replies! Unfortunately I have some other work to
  do, so I can't deal with this problem now, but hopefully in the
  afternoon I will have some time.

  I suspect that the problem is not with name resolution since I use
  the SQL server's IP address in the connection string, so name
  resolution is not needed at all.

  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! :)

Anyway, thanks for Your help!
Peter Neumann

Thursday, January 27, 2005, 6:38:02 AM, you wrote:

> 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