mono linux blob performance issue

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Sao
Posts: 10
Joined: Sat 23 Apr 2011 12:52

Thank you!

Post by Sao » Mon 18 Jul 2011 14:50

I'll wait for test program.

cray
Posts: 11
Joined: Mon 30 Sep 2013 19:12

Re: mono linux blob performance issue

Post by cray » Mon 30 Sep 2013 19:25

I'm experiencing a similar problem with slow performance on mono/linux, but normal on windows. Was this issue address outside of the forum? Did the program ever get sent to the individual above?

Shalex
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

Re: mono linux blob performance issue

Post by Shalex » Thu 03 Oct 2013 14:02

We are working on the test program at the moment.

cray
Posts: 11
Joined: Mon 30 Sep 2013 19:12

Re: mono linux blob performance issue

Post by cray » Thu 03 Oct 2013 14:04

Excellent, thank you.

Shalex
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

Re: mono linux blob performance issue

Post by Shalex » Fri 04 Oct 2013 15:28

@cray
Please give us the following information:
1) do you run the code on the same workstation where Oracle server resides?
2) the name and version of your Linux distributive where you run the code
3) the version of Mono installed
4) the versions of your dotConnect for Oracle (x.xx.xxx) and Oracle server (x.xx)

cray
Posts: 11
Joined: Mon 30 Sep 2013 19:12

Re: mono linux blob performance issue

Post by cray » Fri 04 Oct 2013 15:39

1) No, the code runs on a linux virtual machine, the Oracle database I'm connecting to is on a different server, however they are on the same LAN network, so speeds should be intra-network LAN speeds.

2) Ubuntu Server 12.10 (GNU/Linux 3.5.0-17-generic x86_64)

3) Mono JIT compiler version 2.10.8.1 (Debian 2.10.8.1-5ubuntu1)

4)
-Devart.Data.dll (5.0.792.0)
-Devart.Data.Oracle.dll (7.9.333.0)
-Oracle: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

Mind you, the subject says "blob" performance. However this extends to all over-the-wire data. I can have a simple DataReader be exponentially slower on the aforementioned configuration than on Windows.

Oh and, using the oracle client System.Data.OracleConnection (not Devart) on the exact same box (it is installed), is just as fast as windows. So it's specifically the devart assembly that has the performance issue.

Thanks guys!

Shalex
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

Re: mono linux blob performance issue

Post by Shalex » Mon 14 Oct 2013 11:14

@cray
We have just sent test programs to you. If you didn't receive our e-mail, please check your spam-filter and provide us with an alternative e-mail.

cray
Posts: 11
Joined: Mon 30 Sep 2013 19:12

Re: mono linux blob performance issue

Post by cray » Mon 14 Oct 2013 13:54

Shalex wrote:@cray
We have just sent test programs to you. If you didn't receive our e-mail, please check your spam-filter and provide us with an alternative e-mail.
I haven't received an email. I sent a message to the contact form you provided and referenced this post with an alternate email to use. Thank you.

Shalex
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

Re: mono linux blob performance issue

Post by Shalex » Mon 14 Oct 2013 14:21

Just sent to the alternative e-mail.

cray
Posts: 11
Joined: Mon 30 Sep 2013 19:12

Re: mono linux blob performance issue

Post by cray » Mon 14 Oct 2013 14:23

Shalex wrote:Just sent to the alternative e-mail.
Got it, will run and report back the first chance I get

cray
Posts: 11
Joined: Mon 30 Sep 2013 19:12

Re: mono linux blob performance issue

Post by cray » Tue 15 Oct 2013 19:44

cray wrote:Got it, will run and report back the first chance I get
I'm still waiting on 'approval' to get a test user setup in our dev oracle environment... Ya know how it is :) I'm on vacation after today until Monday. I'll check back then.

cray
Posts: 11
Joined: Mon 30 Sep 2013 19:12

Re: mono linux blob performance issue

Post by cray » Thu 24 Oct 2013 20:08

The output of the mono app was:
Round-trip -> Time: 00:00:00.1333010; Speed: 73 kB/s

I feel like an idiot though, I cannot figure out how to run the delphi program.

...
-rwxrwxrwx 1 cray 8.6M Oct 24 14:59 project1
$sudo ./project1
sudo: unable to execute ./project1: No such file or directory

Shalex
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

Re: mono linux blob performance issue

Post by Shalex » Fri 25 Oct 2013 13:30

Please make sure that the project1 file exists in the current directory when you are executing "./project1" (without quotes).

cray
Posts: 11
Joined: Mon 30 Sep 2013 19:12

Re: mono linux blob performance issue

Post by cray » Fri 25 Oct 2013 14:17

It does. See output of ls and my subsequent attempt to run the program below. Do I need something special installed to execute delphi programs?

cray@[hostname]:~/devart_test/project1$ ls -oah
total 8.6M
drwxrwxr-x 2 cray 4.0K Oct 24 14:59 .
drwxrwxr-x 3 cray 4.0K Oct 24 14:59 ..
-rwxrwxrwx 1 cray 8.6M Oct 24 14:59 project1
cray@[hostname]:~/devart_test/project1$ sudo ./project1
sudo: unable to execute ./project1: No such file or directory
cray@[hostname]:~/devart_test/project1$

Shalex
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

Re: mono linux blob performance issue

Post by Shalex » Mon 28 Oct 2013 10:26

You're probably trying to run a 32-bit binary on a 64-bit system that doesn't have 32-bit support installed: http://stackoverflow.com/questions/2716 ... g-a-binary. Please install 32-bit support and try again.

Post Reply