SQL query

View: New views
3 Messages — Rating Filter:   Alert me  

SQL query

by Sagi Rotem :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi guys ,
 
I am looking for a way to view the SQL queries generated by the .xml query that I wrote.
Is there a way to see them ? like maybe a DEBUG mode or a verbose mode ?
 
Thanks,
Sagi

Re: SQL query

by Joachim Worringen :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Sagi Rotem wrote:
> Hi guys ,
>  
> I am looking for a way to view the SQL queries generated by the .xml
> query that I wrote.
> Is there a way to see them ? like maybe a DEBUG mode or a verbose mode ?

Hi Sagi,

just use the --debug switch. It will print most of the SQL queries that are
performed plus some additional info.

For you, a switch like --sql might be useful to just trace all SQL activity. Not
implemented yet, but no big deal.

Also, if you are an SQL expert (I am not), you will most likely find ways to
optimize the database setup/layout and queries. Any hints are welcome!

  Joachim

--
Joachim Worringen - NEC C&C research lab St.Augustin
fon +49-2241-9252.20 - fax .99 - http://www.ccrl-nece.de

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...


Parent Message unknown RE: SQL query

by Sagi Rotem :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Thanks !
Sagi  

-----Original Message-----
From: Joachim Worringen [mailto:joachim@...]
Sent: Thursday, April 06, 2006 12:16 PM
To: users@...
Subject: Re: [perfbase-users] SQL query

Sagi Rotem wrote:
> Hi guys ,
>  
> I am looking for a way to view the SQL queries generated by the .xml
> query that I wrote.
> Is there a way to see them ? like maybe a DEBUG mode or a verbose mode
?

Hi Sagi,

just use the --debug switch. It will print most of the SQL queries that
are performed plus some additional info.

For you, a switch like --sql might be useful to just trace all SQL
activity. Not implemented yet, but no big deal.

Also, if you are an SQL expert (I am not), you will most likely find
ways to optimize the database setup/layout and queries. Any hints are
welcome!

  Joachim

--
Joachim Worringen - NEC C&C research lab St.Augustin fon
+49-2241-9252.20 - fax .99 - http://www.ccrl-nece.de

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...