Problem with Bayes DB

On Wed, 2006-11-15 at 14:56 -0800, Robert LeBlanc wrote:

> 
> I suspect it's because Maia uses SQL for so many more
things than just
> the Bayes and AWL databases.  The query load on the SQL
server is
> heavier

That, and Maia also has a web interface. If an e-mail
message takes an
extra 30 seconds to reach its destination, it's unlikely
anyone would
even notice. But when you're waiting 30 seconds for that web
page to
load, the slowness is evident. Hardly anyone outside of this
list even
realizes that I've had to disable Bayes in SpamAssassin, but
I'm getting
my door beaten down over the slow web site.

--Greg


_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


On Nov 15, 2006, at 11:23 PM, Greg Woods wrote:


> realizes that I've had to disable Bayes in
SpamAssassin, but I'm  
> getting
> my door beaten down over the slow web site.

The current trunk has some improved queries over 1.0.1 which
will  
help the web speed.


David Morton
Maia Mailguard http://www.maiamailguard
.com
mortondadgrmm.net



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (Darwin)

iD8DBQFFXA3WUy30ODPkzl0RAhaBAJ9PoB1jk0oYBxHqV3xGX0Xd3HdxbgCf
S/YJ
Ht11Y5Eb2KUo+hhU5hfoRG0=
=E5a3
-----END PGP SIGNATURE-----
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users

On Thu, 2006-11-16 at 01:05 -0600, David Morton wrote:

> The current trunk has some improved queries over 1.0.1
which will  
> help the web speed.

Not ever having tried an in-place Maia upgrade on a
production system:
can someone else who as done that give me an idea of how
hard it is? I
presume it's not as easy as just untarring a new set of PHP
scripts and
redoing the local changes I've made (only a few of those,
fortunately)?

--Greg



_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Greg Woods wrote:
> On Thu, 2006-11-16 at 01:05 -0600, David Morton wrote:
> 
>> The current trunk has some improved queries over
1.0.1 which will  
>> help the web speed.
> 
> Not ever having tried an in-place Maia upgrade on a
production system:
> can someone else who as done that give me an idea of
how hard it is? I
> presume it's not as easy as just untarring a new set of
PHP scripts and
> redoing the local changes I've made (only a few of
those, fortunately)?

Depends on what version you are running.   If you are on
1.0.1, I don't think
there were any database changes..   But you can run the
admin/upgrade.php once
you're ready to switch, and it will update the database as
needed.

Of course, it's always best to make a copy of your database
and create a test
environment first before working on the production server!


- --
David Morton
Maia Mailguard                        - http://www.maiamailguard
.com
Morton Software Design and Consulting - http://www.dgrmm.net
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.2 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org


iD8DBQFFXI0uUy30ODPkzl0RAmAmAKCp9LkMm549SCTQAzx8CMjhkTmkEwCf
Z0Hi
85KlaLLpxwkKxMHrvfhzpd0=
=uFSO
-----END PGP SIGNATURE-----
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users