[web2py] Re: Turning off SQL Logging

2013-05-23 Thread Abhishek Gupta
No, .table files aren't deleted or corrupted. Most of the output are of the type timestamp: XXX ALTER TABLE YYY DROP COLUMN ZZZ; faked! Regards Abhishek Gupta Co-founder, Zumbl Zumbl | Facebook | Twitter

[web2py] Re: Turning off SQL Logging

2013-05-23 Thread Anthony
I was just wondering because I think writing to sql.log should only happen when there are actual changes to the table definitions (or if the *.table files are deleted or become corrupted). If you're not making any changes to the schema or touching the *.table files, I wouldn't think the sql.log

[web2py] Re: Turning off SQL Logging

2013-05-23 Thread Abhishek Gupta
No, we aren't doing anything that requires fake_migrations to be true. I did it because of the peculiar needs that we had : Live Server - One domain - One database Dev Server - Multiple domains/web2py installations - Shared database Generally, when we make any change in db, I set migrate=True for

[web2py] Re: Turning off SQL Logging

2013-05-23 Thread Anthony
Are you doing something that requires fake migrations every day (presumably multiple times per day)? Are the *.table files getting deleted? On Thursday, May 23, 2013 12:04:32 PM UTC-4, Abhishek Gupta wrote: > > Anthony, that souns good, thanks. > Massimo, our sql.log grows to almost 1GB each day.

[web2py] Re: Turning off SQL Logging

2013-05-23 Thread Abhishek Gupta
Anthony, that souns good, thanks. Massimo, our sql.log grows to almost 1GB each day. I used fake_migrate=True for all the tables. Regards Abhishek Gupta Co-founder, Zumbl Zumbl | Facebook | Twitter

[web2py] Re: Turning off SQL Logging

2013-05-23 Thread Anthony
I believe sql.log only records the SQL for migrations (i.e., table creation, altering tables, and truncating tables), so logging will be disabled if you disable migrations. Anthony On Thursday, May 23, 2013 12:16:20 AM UTC-4, Abhishek Gupta wrote: > > Hi, > > Is there an easy way to disable the

[web2py] Re: Turning off SQL Logging

2013-05-23 Thread Massimo Di Pierro
No, but why? On Wednesday, 22 May 2013 23:16:20 UTC-5, Abhishek Gupta wrote: > > Hi, > > Is there an easy way to disable the logs generated in databases/sql.log > other than editing gluon/dal.py? > > Regards > Abhishek Gupta > Co-founder, Zumbl > -- --- You received this message because you