> So derby is rock solid? That's not what I said. I just said it's better than the previously existing maildir... If you want rock solid performance at scale with minimal dependencies please check the proposed new PostgreSQL backend: https://github.com/apache/james-project/pull/2587 It is on par quality wise with the distributed version of APache James but runs with less dependencies (those are mostly optional in order to ease single node deployments) > How about degradation after alot of eMails in base? True for all implementations not leveraging mail content storage on dedicated solutions, like S3 object stores to be honnest. Which the PG implem leverages... If retaining performance at scale is a concern of you, maybe you should get a serious look to the PG application. If so, I would happily prvide assistance doing so. Best regards, Benoit TELLIER

On 29/01/2025 12:45, Ilya Terskov wrote:
So derby is rock solid? How about degradation after alot of eMails in base?

ср, 29 янв. 2025 г., 18:16btell...@linagora.com  <btell...@linagora.com>:

Reindexing is only for the search index, handled with Lucene
Not for the Derby DB itself that leverages SQL transactions to remain
strongly consistant.
Best regards
Benoit

On 29/01/2025 12:13, Ilya Terskov wrote:
Ah so its Derby database which also file method? Its good? As i
understand
its can be reindexed and other stuff to manage its consistent state?

ср, 29 янв. 2025 г., 18:09btell...@linagora.com  <btell...@linagora.com
:

Hello Ilya
Maildir implementation for James was unsecure, unmaintained, and was a
pain for the entire project. JPA implem is more prformant than it so it
had been removed.
I discourage its usage.
JPA for you shall work fine.
Best regards
Benoit

On 29/01/2025 12:05, Ilya Terskov wrote:
Thanks for info about jdbc, for small office like 100-150 mails per
weak
maildir mailbox file method is fine solution?
Ah already see 3.8.2 binaries on
https://dlcdn.apache.org/james/server/3.8.2/

ср, 29 янв. 2025 г., 15:56 Benoit TELLIER<btell...@apache.org>:

Hello,

jpa-guice should be working decently with Microsoft SQL server.

We would anyway be happy of feedback regarding this.

Note that it's the same JPA implem than the Spring one, nothing
specific
to Guice.

Here is how to customize the JDBC driver:


https://github.com/apache/james-project/blob/master/server/apps/jpa-app/README.adoc#using-alternative-jdbc-drivers
Hope it helps,

Warm regards,

Benoit

On 29/01/2025 02:04, Ilya Terskov wrote:
Hi there guys. Can you tell me guice working just fine with Microsoft
sql
server? I need odbc driver and other stuff as i understand? Can
someone
tell me also about creating db in mssql and full checklist if someone
have
experience with such installations?

---------------------------------------------------------------------
To unsubscribe, e-mail:server-user-unsubscr...@james.apache.org
For additional commands, e-mail:server-user-h...@james.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail:server-user-unsubscr...@james.apache.org
For additional commands, e-mail:server-user-h...@james.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail:server-user-unsubscr...@james.apache.org
For additional commands, e-mail:server-user-h...@james.apache.org

Reply via email to