[mantisbt-dev] Logging DB Queries

[John R. <jr...@le...>]

Paul,

I've just hit upon a problem with how we handle db query logging.  It 
seems that even with $g_show_queries_list = OFF, Mantis will still log 
every database query made, even though (IMO) the data is not necessary 
to keep.

This problem crops up during pages that make a lot of database queries, 
and ends causing an OOM issue.  This could be the problem that Daryn was 
having with your dates schema upgrade, and I personally hit it with some 
extended processing and importing pages that I'm developing in plugins 
for my employer.

Is there any sane reason that we should be logging all these queries if 
we're not going to show them?   I know I could just explicitly turn off 
the query logging for these pages, but I don't like that solution as it 
seems kludgy, and I'd prefer that the db_api just be smart enough to 
discard queries if it's not actually going to be displaying them...

Cheers

-- 
John Reese
LeetCode.net