Hello Scott,
On Friday, June 13, 2003, Scott Henderson @ Bunzl Phoenix wrote...

> No one can answer this???   :(

I missed the original... trying to fix mailboxes ;)

[..]

> I have searched the archives and the wiki but haven't found my
> answers: I plan to set up SM for a few hundred users, likely no more
> than 20-30 connected at any one time. SM will connect to an Exchange
> server for the rear end... um, I guess I mean backend :). I have
> MySQL installed on the box.

> Should I use a database for SM? At what point does it become
> valuable? (I know this can't be answered in an exact way)

Usually high loaded servers tend to be better suited for database back
ends as it's generally quicker access times. It also makes things
easier on clustered servers as you can all access the same db back end
that way.

> And am I right in understanding that the value of using a database
> for storage of preferences is better performance? Are there other
> benefits?

Better performance, easier to manage (single db instead of several
hundred files), don't have to worry too much about file permission
issues...

> Besides user preferences and address book entries, what else are
> databases used for in connection with SM?

User prefs, address book, certain plugins store preferences in them
too.

> I will avoid using a db if I can, simply because right now I don't
> know how to admin MySQL or Postgres, etc, but if needed, I'll learn.
> Thanks! Scott

If it's only going to be a handful of users, then stay with file based
options, they tend to be less work if you're just getting started. You
can always migrate later.

-- 
Jonathan Angliss
([EMAIL PROTECTED])



-------------------------------------------------------
This SF.NET email is sponsored by: eBay
Great deals on office technology -- on eBay now! Click here:
http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5
--
squirrelmail-users mailing list
List Address: [EMAIL PROTECTED]
List Archives:  http://sourceforge.net/mailarchive/forum.php?forum_id=2995
List Info: https://lists.sourceforge.net/lists/listinfo/squirrelmail-users

Reply via email to