NEWS From Valentina Team.

[Beatrix Willius]

Hi Ruslan,

as you may remember I store mails in my Valentina databases. Searching for values in From, To or dates is relatively fast. But searching for content in a mail is dog slow. My customers have databases with >100.000 mails. This needs to be fast. Just go into your own mail client and try to search for a text. When I try to do this with my 140.000 mails database this takes over a minute. This is the single task that I want to optimize:

WHERE Message.MessageBody REGEX '(?i)something'

Of course, Lucene has nice other features, too, but these are a second step. I need to have a fast search for a lot of small to medium sized texts. As far as I can see the problem is that the main project is in Java and the rest is somewhat behind. Some years ago Java was no problem on the Mac side, but today Java is second class citizen.

On 29.11.2013, at 20:45, Ruslan Zasukhin <ruslan_zasukhin at valentina-db.com> wrote:

> Hi Beatrix,
> 
> Feature you asking for is not easy. It is not 5 minute and not 5 days.
> And may be not 5 weeks.
> 
> I just cannot say you when ... And if ...
> 
> Also I am not absolutely sure this even have sense.
> 
> 
> * Lucene looks to be HUGE. May be bigger of Valentina itself.
> 
> * I do not see Lucene integrated into mySQL or Postgre or other dbs.
> 
> So what should I answer to you?
> 
> 
> .......
> May be more correctly is to discuss at first what tasks you have?
> Then we can look around what other db have for this tasks
> if they have at all.
> 
> You see?

Mit freundlichen Grüßen/Regards

Trixi Willius

http://www.mothsoftware.com
Mail Archiver X: The email archiving solution for professionals