Campbell, Lance wrote:
I want to log all SQL commands as an executable script file for use in
performance testing. Currently there is a lot of information in the log
that is generated that would not be executable. Below is an example of
what I would want to see; which is just the SQL.
Example of log output:
Select a,b,c from calendar where a=12;
Select a,b,c from calendar where a=13;
Hi,
Wouldn't SQL statements in log possible be out of order, also transaction info
would be missing?
Even if you do it in application-side, logging query start time and transaction
info, and feed this data to some application that starts to excecute them in
correct time and context, you wouldnt be able to reliably replicate exact
behavior, cause configuration change might change query times too much.
But i see it _can_ be useful in some cases.
Rigmor
How do I do this?
Thanks,
Lance Campbell
Project Manager/Software Architect
Web Services at Public Affairs
University of Illinois
217.333.0382
http://webservices.uiuc.edu
!DSPAM:5,45b7c785287772091230466!
--
Rigmor Ukuhe
Finestmedia Ltd | Software Development Team Manager
gsm : (+372)56467729 | tel : (+372)6558043 | e-mail : [EMAIL PROTECTED]
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
