Hi, Nice to have antoher Baruwa user :-)
On Wed, Feb 15, 2012 at 11:56 AM, ManicD <[email protected]> wrote: > Baruwa is running VERY slow on teh web interface side of things, i can only > assume its the accessing teh sql that is causing teh problems. The can be several reason for this: Try enableling this: http://www.mydigitallife.info/enable-logging-of-slow-queries-slow-query-log-in-mysql-database/ This will tell us what quries that are slow. > > 1) how do i reduce the quarintine period so that we are not storing so many > emails (need to do this anyway only want one month) This is done in the settings.py file in the baruwa installation folder. > 2) how do i speed up sql/web interface as its usage is stupidly slow.... How many rocords are in the table "messages"? What version of baruwa are you runnning, you are probably missing an index? See this issue on github: https://github.com/akissa/baruwa/commit/607b15bbb8cac93ddd585c9725d7fafb6a2f6216#src/baruwa/messages/models.py This is fixed in the latests release, think its 1.1.1 and you are probably running 1.1.0 You can add it manualy ( Its the Date column that are missing the index ) Hope this helps. > > P.S. i'm not a linux guy, the guy who set this up has run off and i'm > picking up teh peices, i'm fairly competant but not amazing. so be kind.... Other than you type "the" as "teh" a few places, this should be really simple to fix. > > Ash > > -- > View this message in context: > http://baruwa-users-list.963389.n3.nabble.com/Baruwa-VERY-slow-tp3746553p3746553.html > Sent from the Baruwa users list mailing list archive at Nabble.com. > _______________________________________________ > Keep Baruwa FREE - http://pledgie.com/campaigns/12056 _______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056
