Re: query progress bar

2005-05-17 Thread Scott David Daniels
f wrote: > Timothy Smith wrote: > >> is it possible to mke a progress bar for queries? say i have a query >> that will take 20 seconds, i'd like to give some feed back to users on >> how long this will take. > an activity widget, something moving (ie throbber in wxPython) > while waiting fo

Re: query progress bar

2005-05-17 Thread Timothy Smith
Bernhard Holzmayer wrote: >Timothy Smith wrote: > > > >>i'm using pypgsql >> >> > >Assuming you work with PostgreSQL, then: >You know the EXPLAIN command? > >EXPLAIN will give you a very accurate estimation for the expense for the >query. >(You'll have to find out what cost means in terms o

Re: query progress bar

2005-05-17 Thread Bernhard Holzmayer
Timothy Smith wrote: > i'm using pypgsql Assuming you work with PostgreSQL, then: You know the EXPLAIN command? EXPLAIN will give you a very accurate estimation for the expense for the query. (You'll have to find out what cost means in terms of your progress.) I did never try this using pypgsq

Re: query progress bar

2005-05-17 Thread f
Timothy Smith wrote: > is it possible to mke a progress bar for queries? say i have a query > that will take 20 seconds, i'd like to give some feed back to users on > how long this will take. it is strictly impossible to predict that cause of network load, server load, query complexity i

Re: query progress bar

2005-05-16 Thread Timothy Smith
Harald Massa wrote: >>it's for wx, the problem isn't making the progress bar itself, it's >>knowing how long the query is going to run for. >>i'm using pypgsql >> >> > >It is quite easy: > >from timemachine import oracle > >guesser=oracle(guess="SQL") >guesser.set_hint(driver="pypgsql") >gues

Re: query progress bar

2005-05-16 Thread Harald Massa
> it's for wx, the problem isn't making the progress bar itself, it's > knowing how long the query is going to run for. > i'm using pypgsql It is quite easy: from timemachine import oracle guesser=oracle(guess="SQL") guesser.set_hint(driver="pypgsql") guesser.set_hint(gui="wx") expected_runtim

Re: query progress bar

2005-05-16 Thread Timothy Smith
[EMAIL PROTECTED] wrote: >What type of UI is this for? The Python Cookbook, 2nd Ed. has a nice >textual solution. I'm not sure if this is the same one, but here is href="http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/168639";>one >from ASPN. Here is one href="http://wxpython.org/docs/api/

Re: query progress bar

2005-05-16 Thread [EMAIL PROTECTED]
What type of UI is this for? The Python Cookbook, 2nd Ed. has a nice textual solution. I'm not sure if this is the same one, but here is http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/168639";>one from ASPN. Here is one http://wxpython.org/docs/api/wx.ProgressDialog-class.html";> for wxPyt