I was investigating some issues with an AbleCommerce installation and came across a log file named sql.log which is huge. Is there a way to shut this logging off or rotate this file somehow as the file is now more than a GB large and that seem unnecessary. I do have the back end source code and I cannot find any reference to this file.
Also I am noticing that when I refresh a product page that it might be quick for 8 out of the 10 page loads but 2 of them will be extremely slow. I realize that slowness questions are pretty broad but any ideas on things to look for here? Does able commerce cache pages? Thanks.
sql.log
Re: sql.log
I found where the log file is created and why it was created. As a heads up if you build the back end source in debug mode this log file will be created.