Is there currently a syntax to log every incoming SQL query to a file? I found options like: 1) ODBCDEBUG [1] 2) mapi_log(...) [2]
But is there something easy to capture all incoming query with their timings; so a real slow queries log can be created? In the Skyserver presentation [3] I see 'Query log' analysis; I'm really interested in how this is realised. I would like to do an analysis on all queries Mapserver generates by its GDAL/OGR layer, since I have implemented this interface using ODBC (yes, I was too lazy to implement a native connector) some logging would be possible, but not concurrently, hence the file would be overwritten. If nothing is in place, I'm happy to give it a try and implement it. Stefan [1] <http://article.gmane.org/gmane.comp.db.monetdb.devel/1381> [2] <http://monetdb.cwi.nl/projects/monetdb/SQL/Documentation/Mapi-Function-Reference.html> [3] <www.win.tue.nl/~tcalders/presentations/ivanova.ppt> ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Monetdb-developers mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-developers
