Hancock, David (DHANCOCK) wrote: > So, I¹d appreciate any pointers to documentation, code, etc. to let me log > queries to a file.
David, While not exactly what you want, I wrote a simple middleware class to track page-generation stats when calling a view. In it, I count the number of queries and total time spent in them. You could take my class and simply change the part where I'm computing the time to print out each SQL call. Here's the post about it: http://davidavraamides.net/blog/2006/07/03/page-stats-middleware/ And just change this section: # compute the db time for the queries just run queries = len(connection.queries) - n if queries: dbTime = reduce(add, [float(q['time']) for q in connection.queries[n:]]) else: dbTime = 0.0 To something like: # log the sql of each new query queries = len(connection.queries) - n if queries: for q in connection.queries[n:]: logging.info(q['sql']) Hope that helps, -Dave --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users -~----------~----~----~----~------~----~------~--~---
