Re: Converting DB Repository to File Repository

2003-11-26 Thread Kenny Smith
Hi Hut, Yeah, I would assume so too. Unfortunately, I don't have that kind of money. :) Kenny On Nov 26, 2003, at 11:27 AM, Hut Carspecken wrote: Sudip and I experienced the same conflict between the web app and the James. DBfile did help to a lesser extend; however, we noticed a sizable per

RE: Converting DB Repository to File Repository

2003-11-26 Thread Hut Carspecken
Sudip and I experienced the same conflict between the web app and the James. DBfile did help to a lesser extend; however, we noticed a sizable performance gain when we separated the JAMES Mail DB to use a MySQL instance on a separate machine than the web app MySQL. Hut

RE: Converting DB Repository to File Repository

2003-11-25 Thread Noel J. Bergman
> > I would have to check the code in more detail, but if I recall > > correctly, the answer is yes. Old mail will have the entire > > body in the database, new mail will have just the headers in > > the database, and the body in the file system. > If this is true, this would make me _very_ happy

Re: Converting DB Repository to File Repository

2003-11-25 Thread Serge Knystautas
Kenny Smith wrote: If this is true, this would make me _very_ happy. ... since it sounds too good to be true, I'm going to ask just once more. :) I'm sorry to keep bugging. The dbfile repository will look both in the db and on disk for the body of the message, so if it doesn't find it in one p

Re: Converting DB Repository to File Repository

2003-11-25 Thread Kenny Smith
I would have to check the code in more detail, but if I recall correctly, the answer is yes. Old mail will have the entire body in the database, new mail will have just the headers in the database, and the body in the file system. If this is true, this would make me _very_ happy. ... since it s

RE: Converting DB Repository to File Repository

2003-11-25 Thread Noel J. Bergman
> > Try dbfile, instead. It should convert automatically, and dbfile > > should take some of the load off of the database server. > When you say "it should convert automatically", do you mean all of the > mail I currently have in my db will be coverted to be stored with > headers and such in the

Re: Converting DB Repository to File Repository

2003-11-25 Thread Kenny Smith
Hi Noel, Try dbfile, instead. It should convert automatically, and dbfile should take some of the load off of the database server. When you say "it should convert automatically", do you mean all of the mail I currently have in my db will be coverted to be stored with headers and such in the db

RE: Converting DB Repository to File Repository

2003-11-25 Thread Noel J. Bergman
> I think the web app and James are fighting for mysql's attention > during peak activity. So, I'm considering switching James to use > File repositories to alleviate the conflict. Try dbfile, instead. It should convert automatically, and dbfile should take some of the load off of the database se

Converting DB Repository to File Repository

2003-11-18 Thread Kenny Smith
Hi all, I run all of my user and spool repositories via JDBC in addition to a large mysql based web application on my server. I keep having problems with mail and with delays on my web app. I think the web app and James are fighting for mysql's attention during peak activity. So, I'm consideri