On Tue, 2007-03-27 at 11:09 +1000, Malcolm Tredinnick wrote: > On Mon, 2007-03-26 at 19:57 -0500, Greg Donald wrote: > > On 3/26/07, Malcolm Tredinnick <[EMAIL PROTECTED]> wrote: > > > If you want to capture every query automatically like this, you can edit > > > django/db/backends/util.py and put the logging to file in place inside > > > the CursorDebugWrapper.execute() method -- where it is currently > > > appending to self.db.queries. > > > > Thanks. I'm amazed this isn't already a feature. > > That's because it's a really bad idea to do this. > > You will get dozens or hundreds of queries with very little way to tell > which thread or process is doing the logging. Since all the requests > will be interleaved, this will be even harder to track. Serialisation is > also a problem: only one thread or process at a time can write to the > file, so now each simultaneous request has to wait in line to get a lock > in order to access to a single shared resource. Performance would > plummet.
To be fair (because otherwise somebody will claim I'm missing an obvious point), yes, this could be done via syslog on systems that have it available. It is still a performance hit (writing to disk isn't free). I did an experiment early last year to put in calls to the python logging module throughout various paths in Django. It had a noticeable impact. It (logging all queries), is also just not something that's usually that useful. If you are trying to track down a particular problem, a more targeted approach and some experiments at the interactive prompt, combined with printing out connection.queries normally suffices. If you want to see what is sent to the database, connection.queries isn't the accurate answer in any case, because it doesn't show what the database wrapper does as far as quoting goes -- for that, you should be turning on your database's query logging functionality to see the raw data. Regards, Malcolm --~--~---------~--~----~------------~-------~--~----~ 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?hl=en -~----------~----~----~----~------~----~------~--~---
