How Do I Log the Database Activity? (Magic xpa 2.x)
You have the option of logging Magic xpa’s interactions with whatever DBMS you are using. To turn on logging:
-
Go to Options->Settings->Logging.
-
Click on the DBMS tab.
-
Go to the DBMS you want to log.
-
Select a Log Level that isn’t None. There are three logging levels, Customer, Support, and Developer. Customer is the lowest log level, which is the least verbose, and Developer is the highest log level.
|
|
|
|
None
|
No logging is done
|
|
Customer
|
Lowest log level; only SQL commands are generated
|
|
Support
|
Medium log level
|
|
Developer
|
Full log
|
In addition to Magic xpa’s logging, you also might it find it useful to use whatever logging facility is built into the DBMS you are using. These vary depending on the DBMS, but most tools have logging built in.
When using logging, do be sure it is turned off before putting the code into production. Logging significantly slows down the execution of a program.
