Content-Type: multipart/alternative; boundary="_000_86A053629F7BA74295A185835BB4BD0002624CA8ADexlnmb12eurns_" --_000_86A053629F7BA74295A185835BB4BD0002624CA8ADexlnmb12eurns_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Being a tooler myself, I can state one thing - some of these can be show-st= oppers - depending on how the specific end-user views this. There are so ma= ny small things that one can work around. But, then, when doing BAU work, i= t is all too simple to forget to run these workarounds prior to, or alongsi= de your BAU work. Just a thought - not meant to impact a decision, but to r= aise awareness of incorporating 'smaller' items. At times, these can make a= big impact of the overall end user experience and productivity. Have a good day. From: Alexandre Peshansky [mailto:Alex.Peshansky@einstein.yu.edu] Sent: 04 October 2012 14:42 To: squirrel-sql-users@lists.sourceforge.net Subject: Re: [Squirrel-sql-users] Start time or run time for a query before= it has completed Robert, If it can easily be done - great! I was just commenting that it is not a show-stopper, and the user can get t= his information already. -- Alexandre Peshansky, MS Senior Bioinformatics Analyst, Research Informatics Core (RIC) Einstein-Montefiore Institute for Clinical and Translational Research (ICTR= ) Albert Einstein College of Medicine 1300 Morris Park Ave, Mazer Bldg., Rm 534 Bronx, NY 10461 (718) 430-2440 (Mo, Th, Fr) (718) 920-4885 (Tu & We) [cid:image001.png@01CDA242.49EA5E50] From: Robert Manning [mailto:robert.m.manning@gmail.com] Sent: Wednesday, October 03, 2012 5:13 PM To: Alexandre Peshansky Cc: squirrel-sql-users@lists.sourceforge.net Subject: Re: [Squirrel-sql-users] Start time or run time for a query before= it has completed Alexandre, Your approach would work, but I think the feature that Chris is looking for= would be much appreciated by many. I agree with Gerd that Chris' request = is completely reasonable and within the scope of what SQuirreL should do. = In fact, in addition to printing the time taken since an in-progress query = has been initiated, I've long thought that SQuirreL should have some visual= indicator that a query is in progress that captures the user's attention b= esides the "Running query...". Something like a progress bar or swirling i= mage or such. This has been a prominent feature in other competing clients= for some time. Rob On Wed, Oct 3, 2012 at 10:07 AM, Alexandre Peshansky > wrote: On Wed, Oct 03, 2012 5:17 AM, Gerd Wagner wrote: > On 03.10.2012 02:04, Chris Lopes wrote: > > Hi, > > > > Is there any way to know either of the following: > > 1) What time an in-progress query was initiated? > > 2) [related] How long an in-progress query has taken so far? > > > > Obviously the run time of a query is printed out in the log after the > > query completes, but I'd like to be able to know these things before > > it completes. (how long have I been waiting so far?) > No, we don't have that feature yet. But it makes sense and shouldn't be > hard to implement. > > Could you please post a feature request here: > http://sourceforge.net/tracker/?atid=3D393417&group_id=3D28383 What is wrong with just using built-in function for current date and time r= ight before starting the query? For instance, in Oracle I would select sysdate from dual then run the query. -- Alexandre Peshansky, MS Senior Bioinformatics Analyst, Research Informatics Core (RIC) Einstein-Montefiore Institute for Clinical and Translational Research (ICTR= ) Albert Einstein College of Medicine 1300 Morris Park Ave, Mazer Bldg., Rm 534 Bronx, NY 10461 (718) 430-2440 (Mo, Th, Fr) (718) 920-4885 (Tu & We) ---------------------------------------------------------------------------= --- Don't let slow site performance ruin your business. Deploy New Relic APM Deploy New Relic app performance management and know exactly what is happening inside your Ruby, Python, PHP, Java, and .NET app Try New Relic at no cost today and get our sweet Data Nerd shirt too! http://p.sf.net/sfu/newrelic-dev2dev _______________________________________________ Squirrel-sql-users mailing list Squirrel-sql-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users --_000_86A053629F7BA74295A185835BB4BD0002624CA8ADexlnmb12eurns_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Being a tooler myself, I can state one thing – some of these can be show-stoppers – depending on how the specific end-user v= iews this. There are so many small things that one can work around. But, then, w= hen doing BAU work, it is all too simple to forget to run these workarounds pri= or to, or alongside your BAU work. Just a thought – not meant to impact = a decision, but to raise awareness of incorporating ‘smaller’ ite= ms. At times, these can make a big impact of the overall end user experience and productivity.

 

Have a good day.

 

From: Alexandre Peshansky [mailto:Alex.Peshansky@einstein.yu.edu]
Sent: 04 October 2012 14:42
To: squirrel-sql-users@lists.sourceforge.net
Subject: Re: [Squirrel-sql-users] Start time or run time for a query before it has completed

 

Robert,

If it can easily be done – great! 

I was just commenting that it is not a show-stopper, and the user can get this information already.

--

Alexandre Peshansky, MS

Senior Bioinformatics Analyst, Research Informatics Core (RI= C)

Einstein-Montefiore Institute for Clinical and Translational Research (ICTR)

Albert Einstein College of Medicine

1300 Morris Park Ave, Mazer Bldg., Rm 534<= /p>

Bronx, NY 10461

(718) 430-2440 (Mo, Th, Fr)  (718) 920-4885 (Tu & W= e)

3DEinstein-Monti.GIF

 

From: Robert Manning [mailto:robert.m.manning= @gmail.com]
Sent: Wednesday, October 03, 2012 5:13 PM
To: Alexandre Peshansky
Cc: squirrel-sql-users@lists.sourceforge.net
Subject: Re: [Squirrel-sql-users] Start time or run time for a query before it has completed

 

Alex= andre,

Your approach would work, but I think the feature that Chris is looking for would be much appreciated by many.  I agree with Gerd that Chris' requ= est is completely reasonable and within the scope of what SQuirreL should do.&n= bsp; In fact, in addition to printing the time taken since an in-progress query = has been initiated, I've long thought that SQuirreL should have some visual indicator that a query is in progress that captures the user's attention besides the "Running query...".  Something like a progress b= ar or swirling image or such.  This has been a prominent feature in other competing clients for some time.


Rob

On Wed, Oct 3, 2012 at 10:07 AM, Al= exandre Peshansky <Alex.Peshansky@einstein.yu.edu> wrote:

On W= ed, Oct 03, 2012 5:17 AM, Gerd Wagner wrote:
> On 03.10.2012 02:04, Chris Lopes wrote:
> > Hi,
> >
> > Is there any way to know either of the following:
> > 1) What time an in-progress query was initiated?
> > 2) [related] How long an in-progress query has taken so far?
> >
> > Obviously the run time of a query is printed out in the log after= the
> > query completes, but I'd like to be able to know these things bef= ore
> > it completes. (how long have I been waiting so far?)
> No, we don't have that feature yet. But it makes sense and shouldn't b= e
> hard to implement.
>
> Could you please post a feature request here:
> http://sourceforge.net/tracker/?atid=3D393417&group_i= d=3D28383

What is wrong with just using built= -in function for current date and time right before starting the query?
For instance, in Oracle I would

select sysdate from dual

then run the query.
--
Alexandre Peshansky, MS
Senior Bioinformatics Analyst, Research Informatics Co= re (RIC)
Einstein-Montefiore Institute for Clinical and Transla= tional Research (ICTR)
Albert Einstein College of Medicine
1300 Morris Park Ave, Mazer Bldg., Rm 534
Bronx, NY 10461
(718) 430-2440 (Mo, Th, Fr)  (718) 920-4885 (Tu &= amp; We)




---------------------------------------------------------------------------= ---
Don't let slow site performance ruin your business. Deploy New Relic APM Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p= .sf.net/sfu/newrelic-dev2dev
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-us= ers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql= -users

 

--_000_86A053629F7BA74295A185835BB4BD0002624CA8ADexlnmb12eurns_--