On Mon, Jul 22, 2013 at 10:37 AM, Dinesh Kumar < dinesh.ku...@enterprisedb.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.ku...@enterprisedb.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 <dp...@pgadmin.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.ku...@enterprisedb.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 <dp...@pgadmin.org> wrote: >>>> >>>>> On Wed, Jul 17, 2013 at 4:53 PM, Philip Luppens >>>>> <philip.lupp...@gmail.com> wrote: >>>>> > On Wed, Jul 17, 2013 at 5:41 PM, Dave Page <dp...@pgadmin.org> >>>>> wrote: >>>>> >> >>>>> >> On Wed, Jul 17, 2013 at 4:36 PM, Philip Luppens >>>>> >> <philip.lupp...@gmail.com> wrote: >>>>> >> > >>>>> >> > >>>>> >> > >>>>> >> > On Wed, Jul 17, 2013 at 5:28 PM, Dave Page <dp...@pgadmin.org> >>>>> wrote: >>>>> >> >> >>>>> >> >> Hi >>>>> >> >> >>>>> >> >> On Wed, Jul 17, 2013 at 4:23 PM, Philip Luppens >>>>> >> >> <philip.lupp...@gmail.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_b6r2gu...@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@postgresql.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
