Re: [Pharo-users] Pharo performance

2013-08-01 Thread Stéphane Ducasse
ok so we will create a private business mailing-list Stef On Jul 30, 2013, at 11:41 PM, p...@highoctane.be wrote: > Yes, as discussed, I am pushing Pharo and discussing business in the open > just doesn't work for me.

Re: [Pharo-users] Pharo performance

2013-08-01 Thread Mariano Martinez Peck
you will need OpenDBX lib and FFI. > > -- > *From:* Mariano Martinez Peck > *To:* Any question about pharo is welcome > *Sent:* Wednesday, 31 July 2013, 22:40 > *Subject:* Re: [Pharo-users] Pharo performance > > > > > On Wed, Jul 31, 2013 at 6:32 PM, Chris wrote: >

Re: [Pharo-users] Pharo performance

2013-08-01 Thread CHRIS BAILEY
rence when something is implemented on top of C and libpq (I presume) From: Mariano Martinez Peck To: Any question about pharo is welcome Sent: Wednesday, 31 July 2013, 22:40 Subject: Re: [Pharo-users] Pharo performance On Wed, Jul 31, 2013 at 6:32 PM, Chris

Re: [Pharo-users] Pharo performance

2013-07-31 Thread Mariano Martinez Peck
On Wed, Jul 31, 2013 at 6:32 PM, Chris wrote: > It definitely seems to be because most things in the V2 driver are coming > in as strings and then being converted. Running the same query on the three > systems gives the following for a 65000 double array > > PGV2 770m/s > PGV3 200m/s > Psycopg2 1

Re: [Pharo-users] Pharo performance

2013-07-31 Thread Chris
It definitely seems to be because most things in the V2 driver are coming in as strings and then being converted. Running the same query on the three systems gives the following for a 65000 double array PGV2 770m/s PGV3 200m/s Psycopg2 130m/s Now I just need to find out how to get PGV3 as the

Re: [Pharo-users] Pharo performance

2013-07-30 Thread p...@highoctane.be
Yes, as discussed, I am pushing Pharo and discussing business in the open just doesn't work for me.

Re: [Pharo-users] Pharo performance

2013-07-30 Thread Stéphane Ducasse
yes normally there is one :) Now I will check who is in. What we should pay attention is that we are not really in favor of private discussions (even if I understand it fr business it is important). If you think that this would be good we can create a private business list. Stef > BTW, is there

Re: [Pharo-users] Pharo performance

2013-07-30 Thread p...@highoctane.be
BTW, is there any special consortium list where we can discuss business out of the public eye? --- Philippe Back Dramatic Performance Improvements Mob: +32(0) 478 650 140 | Fax: +32 (0) 70 408 027 Mail:p...@highoctane.be | Web: http://philippeback.eu Blog: http://philippeback.be | Twitter: @philip

Re: [Pharo-users] Pharo performance

2013-07-30 Thread Stéphane Ducasse
>> > > You could try: > > | floats | > floats := (1 to: 20) collect: #asFloat. > [ FloatPrintPolicy >value: InexactFloatPrintPolicy new >during: [ >String new: 150 streamContents: [ :stream | >floats do: [ :each | each printOn: stream ] ] ] ] timeToRun >

Re: [Pharo-users] Pharo performance

2013-07-30 Thread Chris
It was 6 doubles from the double precision[] type. Having had a very small look, it's possible that it isn't even supported and someone at our end has hacked the float converter to parse each one out, so I think it must be coming in as a string. Hi Yanni, On 30 Jul 2013, at 05:17, Yanni

Re: [Pharo-users] Pharo performance

2013-07-30 Thread Esteban A. Maringolo
2013/7/30 Igor Stasenko : >> [ self execute: 'select longitude,latitude from log_data limit 1;' ] >> timeToRun. >> >> => 76 ms >> > 76 ms for 1 records? > that's quite good throughput i would say. That will depend on the cursor type being used for the query. If it's just opening the curs

Re: [Pharo-users] Pharo performance

2013-07-30 Thread Igor Stasenko
On 30 July 2013 10:42, Sven Van Caekenberghe wrote: > Hi Yanni, > > On 30 Jul 2013, at 05:17, Yanni Chiu wrote: > >> On 29/07/13 7:08 PM, Sven Van Caekenberghe wrote: >>> >>> The explanation for the slowdown must be in the PgV2 driver. >> >> The PgV2 protocol is described at: >> http://www.postg

Re: [Pharo-users] Pharo performance

2013-07-30 Thread Sven Van Caekenberghe
Hi Yanni, On 30 Jul 2013, at 05:17, Yanni Chiu wrote: > On 29/07/13 7:08 PM, Sven Van Caekenberghe wrote: >> >> The explanation for the slowdown must be in the PgV2 driver. > > The PgV2 protocol is described at: > http://www.postgresql.org/docs/7.1/static/protocol-message-formats.html > > Ha

Re: [Pharo-users] Pharo performance

2013-07-29 Thread Esteban Lorenzano
btw, one of the reasons why I would like to (some day) rewrite the DBXTalk Driver getting rid of opendbx is because it answers always strings (char*) [1], which at the time needs to be parsed too... slowing a lot the process. but well, since it is not an easy task, it will be delayed indefinitel

Re: [Pharo-users] Pharo performance

2013-07-29 Thread Yanni Chiu
On 29/07/13 7:08 PM, Sven Van Caekenberghe wrote: The explanation for the slowdown must be in the PgV2 driver. The PgV2 protocol is described at: http://www.postgresql.org/docs/7.1/static/protocol-message-formats.html Have a glance at the "AsciiRow" and "BinaryRow" message formats. The dri

Re: [Pharo-users] Pharo performance

2013-07-29 Thread Mariano Martinez Peck
I forward Nico's answer because he is not in the mailing list. On Mon, Jul 29, 2013 at 6:12 PM, Nicolas Cellier < nicolas.cellier.aka.n...@gmail.com> wrote: > First thing, printing a Float correctly is a difficult task. > > Let's remind the requirements for a decimal printString: > 1) every two d

Re: [Pharo-users] Pharo performance

2013-07-29 Thread Sven Van Caekenberghe
On 29 Jul 2013, at 23:20, Chris wrote: > On 29/07/2013 21:33, Sven Van Caekenberghe wrote: >> Chris, >> >> On 29 Jul 2013, at 20:52, Chris wrote: >> >>> I've been getting a little concerned with certain aspects of performance >>> recently. Just a couple of examples off the top of my head wer

Re: [Pharo-users] Pharo performance

2013-07-29 Thread Chris
On 29/07/2013 21:33, Sven Van Caekenberghe wrote: Chris, On 29 Jul 2013, at 20:52, Chris wrote: I've been getting a little concerned with certain aspects of performance recently. Just a couple of examples off the top of my head were trying to do a printString on 20 floats which takes ov

Re: [Pharo-users] Pharo performance

2013-07-29 Thread Sven Van Caekenberghe
Chris, On 29 Jul 2013, at 20:52, Chris wrote: > I've been getting a little concerned with certain aspects of performance > recently. Just a couple of examples off the top of my head were trying to do > a printString on 20 floats which takes over 3 seconds. If I do the same > in Python it

Re: [Pharo-users] Pharo performance

2013-07-29 Thread Mariano Martinez Peck
I remember Nicolas Cieller did something about improving performance of Float printing. Not sure what is the state yet On Mon, Jul 29, 2013 at 4:50 PM, Chris wrote: > I often use the profiler :) > > The float printString is all fairly evenly split which is why I mention > about whether a

Re: [Pharo-users] Pharo performance

2013-07-29 Thread Chris
I often use the profiler :) The float printString is all fairly evenly split which is why I mention about whether another implementation may be required. I'll always raise anything much more obvious that I see! Hi Chris, My recommendation in this case is always do not spend a single second

Re: [Pharo-users] Pharo performance

2013-07-29 Thread Mariano Martinez Peck
Hi Chris, My recommendation in this case is always do not spend a single second trying to figure out what is the bottleneck by yourself. First thing ever to do, is to run a profiler. You can do that very easily in Pharo. TimeProfiler spyOn: [ Transcript show: 'do something for real here to benchm

[Pharo-users] Pharo performance

2013-07-29 Thread Chris
I've been getting a little concerned with certain aspects of performance recently. Just a couple of examples off the top of my head were trying to do a printString on 20 floats which takes over 3 seconds. If I do the same in Python it is only 0.25 seconds. Similarly reading 65000 points fro