NEWS From Valentina Team.

[jda]

You’re indexing by word? I’ve found such searches to be far, far faster than regex searches (which is why they’re used, of course).

Try a left() search for example.

And if you don’t need all the fields returned in the cursor, don’t use *, name the fields you want retrieved.

I only use regex when I want searches that return punctuation (i.e. string searches), and they’re considerably slower.

Jon



> Why should I avoid them? Of course, MessageBody is indexed, but I found that regex search is faster than * search.
> 
> On 30.11.2013, at 14:12, jda <jda at his.com> wrote:
> 
>> Are you avoiding indexed searches for some reason?
> 
> Mit freundlichen Grüßen/Regards
> 
> Trixi Willius
> 
> http://www.mothsoftware.com
> Mail Archiver X: The email archiving solution for professionals
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina