One small point to bear in mind - for many of us there IS no SQL. It
depends on the database in use (and your style of using it, I guess).

It seems to me that the instrumentation (in terms of timing at least)
should be at the boss_db level so that it applies to ALL databases - then
the individual database drivers are free to add some extra info, such as
the SQL used (for a SQL database), or the strategy/models/whatever selected
(for the no-SQL databases).

I use Mnesia, so I am not sure I can even spell SQL any more, but I too
would like to know where my database time is being spent because it can
also give valuable insights into possible inefficiencies in the app e.g.
re-reading the same record multiple times.

Cheers,

g





On 4 April 2014 03:19, David Welton <[email protected]> wrote:

> What I want is something really similar to what Rails has, where each
> query gives me the actual SQL generated, and how long it took to run,
> so that I can think about where time is being spent, and also see what
> the underlying SQL is like.
>
> On Thu, Apr 3, 2014 at 8:48 PM, Andreas Stenius
> <[email protected]> wrote:
> > Have you looked at fprof?
> > http://www.erlang.org/doc/man/fprof.html
> >
> > --
> > You received this message because you are subscribed to the Google Groups
> > "ChicagoBoss" group.
> > To unsubscribe from this group and stop receiving emails from it, send an
> > email to [email protected].
> > Visit this group at http://groups.google.com/group/chicagoboss.
> > To view this discussion on the web visit
> >
> https://groups.google.com/d/msgid/chicagoboss/CABCxKrfj5zqWBq4r_kyadrS%3D0HZwmUbyruStFq5opG446qctJw%40mail.gmail.com
> .
> > For more options, visit https://groups.google.com/d/optout.
>
>
>
> --
> David N. Welton
>
> http://www.welton.it/davidw/
>
> http://www.dedasys.com/
>
> --
> You received this message because you are subscribed to the Google Groups
> "ChicagoBoss" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> Visit this group at http://groups.google.com/group/chicagoboss.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/chicagoboss/CA%2Bb9R_uC6qVGEBpwFXfv0yR_LUH-rWVasBafovhV3hOvpSdnQw%40mail.gmail.com
> .
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"ChicagoBoss" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
Visit this group at http://groups.google.com/group/chicagoboss.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/chicagoboss/CAKF5fiB%2Bk0BktDykmnp%3D_cLMn-Vow900Yx7Vdqs8-scut%3D%3D%3DUA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to