Re: pgAdmin3 extremely slow while displaying TEXT column values on OSX

On Mon, Jul 22, 2013 at 10:37 AM, Dinesh Kumar <
dinesh(dot)kumar(at)enterprisedb(dot)com> wrote:

> Hi Philip,
>
> Would you mind if i share the file "nseasa_content.zip", with the
> wxWidgets team. Because, i am able to re-produce the case with your
> provided xml file only. I have created a huge length data, which is not in
> xml format and found different issue. I would like to raise BUG with these
> two cases with wxWidgets team. For this, i would like to take confirmation
> from you whether i can share this with wxWidgets team or not.
>
>
> Kindly update me with your inputs.
>

Obviously - feel free to do so if it helps to build a test case.

-Phil

>
> Thanks in advance.
>
>
> Dinesh
>
> --
> *Dinesh Kumar*
> Software Engineer
>
> Ph: +918087463317
> Skype ID: dinesh.kumar432
> www.enterprisedb.co <http://www.enterprisedb.com/>m<http://www.enterprisedb.com/>
> *
> Follow us on Twitter*
> @EnterpriseDB
>
> Visit EnterpriseDB for tutorials, webinars, whitepapers<http://www.enterprisedb.com/resources-community> and
> more <http://www.enterprisedb.com/resources-community>
>
>
> On Thu, Jul 18, 2013 at 8:00 PM, Dinesh Kumar <
> dinesh(dot)kumar(at)enterprisedb(dot)com> wrote:
>
>> Thanks Dave.
>>
>> Sure, will do.
>>
>> Dinesh
>>
>> --
>> *Dinesh Kumar*
>> Software Engineer
>>
>> Ph: +918087463317
>> Skype ID: dinesh.kumar432
>> www.enterprisedb.co <http://www.enterprisedb.com/>m<http://www.enterprisedb.com/>
>> *
>> Follow us on Twitter*
>> @EnterpriseDB
>>
>> Visit EnterpriseDB for tutorials, webinars, whitepapers<http://www.enterprisedb.com/resources-community> and
>> more <http://www.enterprisedb.com/resources-community>
>>
>>
>> On Thu, Jul 18, 2013 at 7:58 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>>
>>> Oh, great - thanks for confirming and taking the initiative to do so.
>>> Can you minimise your app down to a simple test case (ideally a patch
>>> against one of the wxWidgets sample apps,as the wx guys prefer those), and
>>> log a bug on the wxWidgets Trac site?
>>>
>>> Thanks.
>>>
>>>
>>>
>>> On Thu, Jul 18, 2013 at 3:23 PM, Dinesh Kumar <
>>> dinesh(dot)kumar(at)enterprisedb(dot)com> wrote:
>>>
>>>> Hi Dave/Dhiraj,
>>>>
>>>> Sorry for interfering here.
>>>>
>>>> Today i have tested the same case in my local windows machine and
>>>> facing the same problem. I have setup a sample grid environment using code
>>>> blocks IDE and with the data provided. I am able to reproduce the same
>>>> case. Grid is not able to place the many characters like (id=>1113,
>>>> length(content)=>1102145 and id=>1124, length(content)=>2319784). If i
>>>> select all the columns except these two id's then it's fine. If i select
>>>> all the rows including these two rows, then the cpu load is increasing very
>>>> high in my local windows machine. I believe it's the problem with wxWidgets
>>>> or wxGrid internal implementation.
>>>>
>>>> Thanks in advance.
>>>>
>>>> Dinesh
>>>>
>>>> --
>>>> *Dinesh Kumar*
>>>> Software Engineer
>>>>
>>>> Ph: +918087463317
>>>> Skype ID: dinesh.kumar432
>>>> www.enterprisedb.co <http://www.enterprisedb.com/>m<http://www.enterprisedb.com/>
>>>> *
>>>> Follow us on Twitter*
>>>> @EnterpriseDB
>>>>
>>>> Visit EnterpriseDB for tutorials, webinars, whitepapers<http://www.enterprisedb.com/resources-community> and
>>>> more <http://www.enterprisedb.com/resources-community>
>>>>
>>>>
>>>> On Thu, Jul 18, 2013 at 7:17 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>>>>
>>>>> On Wed, Jul 17, 2013 at 4:53 PM, Philip Luppens
>>>>> <philip(dot)luppens(at)gmail(dot)com> wrote:
>>>>> > On Wed, Jul 17, 2013 at 5:41 PM, Dave Page <dpage(at)pgadmin(dot)org>
>>>>> wrote:
>>>>> >>
>>>>> >> On Wed, Jul 17, 2013 at 4:36 PM, Philip Luppens
>>>>> >> <philip(dot)luppens(at)gmail(dot)com> wrote:
>>>>> >> >
>>>>> >> >
>>>>> >> >
>>>>> >> > On Wed, Jul 17, 2013 at 5:28 PM, Dave Page <dpage(at)pgadmin(dot)org>
>>>>> wrote:
>>>>> >> >>
>>>>> >> >> Hi
>>>>> >> >>
>>>>> >> >> On Wed, Jul 17, 2013 at 4:23 PM, Philip Luppens
>>>>> >> >> <philip(dot)luppens(at)gmail(dot)com> wrote:
>>>>> >> >> > Good day everyone,
>>>>> >> >> >
>>>>> >> >> > I'd like to discuss an issue in the current stable version
>>>>> 1.16.1 of
>>>>> >> >> > pgAdmin3 that has been reported before [1], but since no
>>>>> solution was
>>>>> >> >> > reported, I'd like to ask for a bit of followup.
>>>>> >> >> >
>>>>> >> >> > The issue is pretty much as described in [1]: displaying rows
>>>>> with
>>>>> >> >> > type
>>>>> >> >> > TEXT
>>>>> >> >> > with some content (smallish XML documents) renders the
>>>>> application
>>>>> >> >> > unusable
>>>>> >> >> > for a long duration. The retrieval is plenty fast, only the
>>>>> rendering
>>>>> >> >> > in
>>>>> >> >> > pgAdmin3 is affected. Since I have no experience with C++ nor
>>>>> >> >> > wxWidgets,
>>>>> >> >> > I'm
>>>>> >> >> > afraid I cannot offer more than a simple profiling [2]. To the
>>>>> >> >> > untrained
>>>>> >> >> > eye, this seems like a problem in the wxWidgets library
>>>>> (correct me
>>>>> >> >> > if
>>>>> >> >> > I'm
>>>>> >> >> > wrong).
>>>>> >> >> >
>>>>> >> >> > I did some searching in the wxWidgets Traq instance, and all I
>>>>> found
>>>>> >> >> > was
>>>>> >> >> > this issue [3], but I'm not sure it's related - which was
>>>>> >> >> > acknowledged 5
>>>>> >> >> > years ago. Does that mean there's no hope of this getting
>>>>> resolved?
>>>>> >> >> > Or
>>>>> >> >> > is it
>>>>> >> >> > such a minor issue for most people?
>>>>> >> >> >
>>>>> >> >> > In the mean time, I'm using a commercial offering, but I'd
>>>>> rather see
>>>>> >> >> > the
>>>>> >> >> > pgAdmin3 tool getting a fix for OSX developers. However, if
>>>>> this
>>>>> >> >> > boils
>>>>> >> >> > down
>>>>> >> >> > to 'not our fault - go and bug the wxWidgets guys', then I
>>>>> completely
>>>>> >> >> > understand that.
>>>>> >> >> >
>>>>> >> >> > Cheers,
>>>>> >> >> >
>>>>> >> >> > Phil
>>>>> >> >> >
>>>>> >> >> >
>>>>> >> >> > [1]
>>>>> >> >> >
>>>>> >> >> >
>>>>> >> >> >
>>>>> http://www.postgresql.org/message-id/CAGuHJrMgbCoAnEnEkVXbbZni82n-1re9QD-GRaVv_b6R2GuCdA@mail.gmail.com
>>>>> >> >> > [2] http://i.imgur.com/DMEXeps.png
>>>>> >> >> > [3] http://trac.wxwidgets.org/ticket/4408
>>>>> >> >>
>>>>> >> >> Can you provide a test case that is slow for you? I've never
>>>>> seen such
>>>>> >> >> a problem and use OSX daily.
>>>>> >> >
>>>>> >> >
>>>>> >> > Sure - how would one prepare such a test case? A simple DB dump
>>>>> with
>>>>> >> > data?
>>>>> >>
>>>>> >> Yes please.
>>>>> >
>>>>> >
>>>>> > Ok, I've uploaded an archive [1] - let me know if that works
>>>>> (there's quite
>>>>> > a few options in the backup routine, and I'm not sure which ones I'd
>>>>> need to
>>>>> > select, so give me a shout if I forgot something.
>>>>> >
>>>>> > It contains a single table content with the following structure:
>>>>> >
>>>>> > CREATE TABLE content (
>>>>> > id bigint NOT NULL,
>>>>> > content text,
>>>>> > content_type character varying(10) NOT NULL,
>>>>> > documentid character varying(512) NOT NULL
>>>>> > );
>>>>> >
>>>>> >
>>>>> > Any display of the records in the table via pgAdmin results
>>>>> immediately in a
>>>>> > complete lockdown of the application for +/- 30 seconds, and results
>>>>> in the
>>>>> > profiling that I've linked to in the OP.
>>>>> >
>>>>>
>>>>> Hi
>>>>>
>>>>> Thanks - I can reproduce this on a 16GB machine as well. It does look
>>>>> to me as if it's likely a wxWidgets issue - if I use pgAdmin 1.18
>>>>> which has a working limit on the number of chars it'll attempt to
>>>>> display in the query tool, it's very fast (when set to 1024), but when
>>>>> opened in the Edit Grid, it takes a significant time to open the
>>>>> table.
>>>>>
>>>>> Dhiraj; can you see if you can do some profiling to confirm whether or
>>>>> not it is wxWidgets, or if we have a bug somewhere please?
>>>>>
>>>>> Thanks.
>>>>>
>>>>> --
>>>>> Dave Page
>>>>> Blog: http://pgsnake.blogspot.com
>>>>> Twitter: @pgsnake
>>>>>
>>>>> EnterpriseDB UK: http://www.enterprisedb.com
>>>>> The Enterprise PostgreSQL Company
>>>>>
>>>>>
>>>>> --
>>>>> Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org)
>>>>> To make changes to your subscription:
>>>>> http://www.postgresql.org/mailpref/pgadmin-support
>>>>>
>>>>
>>>>
>>>
>>>
>>> --
>>> Dave Page
>>> Blog: http://pgsnake.blogspot.com
>>> Twitter: @pgsnake
>>>
>>> EnterpriseDB UK: http://www.enterprisedb.com
>>> The Enterprise PostgreSQL Company
>>>
>>
>>
>

--
"We cannot change the cards we are dealt, just how we play the hand." -
Randy Pausch