[Mono-dev] Performance problem with System.Data

[Nagappan A]

Hi Kosta,

I haven't executed / compiled any of the programs :) FYI.

Attaching what ever with me.

Thanks
Nagappan

On Feb 3, 2008 12:02 AM, Konstantin Triger <kostat at mainsoft.com> wrote:

>  Hi Nagappan,
>
>
>
> As far as I know, when adding many records, the suggested usage of
> DataTable is [BeginLoadData -> add records -> EndLoadData]. In this case the
> performance of both implementation should be roughly similar, but the memory
> footprint of RBTree will be much higher.
>
>
>
> Can you please post the Senganal's test code?
>
>
>
> Regards,
>
> Konstantin Triger
>
> *From:* Nagappan A [mailto:nagappan at gmail.com]
> *Sent:* Saturday, February 02, 2008 11:39 PM
> *To:* Konstantin Triger
> *Cc:* Hubert FONGARNAND; mono-devel-list at lists.ximian.com;
> senganal at gmail.com
> *Subject:* Re: [Mono-dev] Performance problem with System.Data
>
>
>
> Hi Kosta,
>
> RBTree implementation is not directly related to this bug, but I was
> trying to say, in general about the performance of System.Data.
>
> In general RBTree performance is much better than Array based. As per
> Senganal's test result, for adding 1 million records, it took 40 minutes.
> With RBTree implementation, he was able to do them in seconds.
>
> Adding senganal in CC.
>
> Thanks
> Nagappan
>
> 2008/2/2 Konstantin Triger <kostat at mainsoft.com>:
>
> Hey Nagappan,
>
> Can you please explain
> 1. How RBTree implementation will solve the issue in the bug?
> 2. Why do you think RBTree implementation will be superior over Array in
> performance?
>
>
>
> Regards,
> Konstantin Triger
>
>
> --
> Linux Desktop Testing Project - http://ldtp.freedesktop.org
> http://nagappanal.blogspot.com
>



-- 
Linux Desktop Testing Project - http://ldtp.freedesktop.org
http://nagappanal.blogspot.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/mono-devel-list/attachments/20080203/bbfcf591/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: buildindex_1000000_rows_pkey.cs
Type: text/x-csharp
Size: 870 bytes
Desc: not available
Url : http://lists.ximian.com/pipermail/mono-devel-list/attachments/20080203/bbfcf591/attachment.bin 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: index_bug.cs
Type: text/x-csharp
Size: 1458 bytes
Desc: not available
Url : http://lists.ximian.com/pipermail/mono-devel-list/attachments/20080203/bbfcf591/attachment-0001.bin 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: load_1000000_rows_fkey.cs
Type: text/x-csharp
Size: 1571 bytes
Desc: not available
Url : http://lists.ximian.com/pipermail/mono-devel-list/attachments/20080203/bbfcf591/attachment-0002.bin 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: load_1000000_rows_pkey.cs
Type: text/x-csharp
Size: 882 bytes
Desc: not available
Url : http://lists.ximian.com/pipermail/mono-devel-list/attachments/20080203/bbfcf591/attachment-0003.bin 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: load_1000000_rows_pkey_1.cs
Type: text/x-csharp
Size: 829 bytes
Desc: not available
Url : http://lists.ximian.com/pipermail/mono-devel-list/attachments/20080203/bbfcf591/attachment-0004.bin 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: load_dataset_hierarchial_data.cs
Type: text/x-csharp
Size: 1357 bytes
Desc: not available
Url : http://lists.ximian.com/pipermail/mono-devel-list/attachments/20080203/bbfcf591/attachment-0005.bin 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: load_million_no_constraints.cs
Type: text/x-csharp
Size: 433 bytes
Desc: not available
Url : http://lists.ximian.com/pipermail/mono-devel-list/attachments/20080203/bbfcf591/attachment-0006.bin