Re: [sqlite] FTS3 Appropriate usage

2010-04-27 Thread Jens
Hey, Just saw your post. Really interesting stuff. Thanks a bunch! - Jens On Apr 16, 12:24 pm, Alexey Pechnikov wrote: > Hello! > > On Thursday 15 April 2010 11:21:17 Jens wrote: > > > I'd appreciate any feedback you might have one this. Also, does anyone > > have experience with sqlite+ft3 and

Re: [sqlite] FTS3 Appropriate usage

2010-04-16 Thread Scott Hess
On Fri, Apr 16, 2010 at 3:24 AM, Alexey Pechnikov wrote: > And you can use my patches for zlib-compression for FTS3. I'm planning to make > the "fts3z" extension because I want to use as original FTS3 > as FTS3 with compression together. Back when I was working up fts1, I experimented with compre

Re: [sqlite] FTS3 Appropriate usage

2010-04-16 Thread Alexey Pechnikov
Hello! On Thursday 15 April 2010 11:21:17 Jens wrote: > I'd appreciate any feedback you might have one this. Also, does anyone > have experience with sqlite+ft3 and high-availability solutions? Has > anyone done any benchmarking of fts3? I did test FTS3 on about 400 millions of records and there

Re: [sqlite] FTS3 Appropriate usage

2010-04-15 Thread Jens
Thanks for your feedback. I gonna keep my data in my main RDBMS instead (which supports full-text searching as well). If it's too slow, i still have to option of setting up a database cluster or something. On Apr 15, 1:41 pm, Simon Slavin wrote: > On 15 Apr 2010, at 8:21am, Jens wrote: > > > I'd

Re: [sqlite] FTS3 Appropriate usage

2010-04-15 Thread Simon Slavin
On 15 Apr 2010, at 8:21am, Jens wrote: > I'd appreciate any feedback you might have one this. Also, does anyone > have experience with sqlite+ft3 and high-availability solutions? Has > anyone done any benchmarking of fts3? For a start, FTS3 is a very specific solution to a very specific problem.

[sqlite] FTS3 Appropriate usage

2010-04-15 Thread Jens
So I'm building this web-site solution where high performance is a clear requirement. Pages content should not be static, but rather put together on the basis of supplied search criteria (basically tags); The page must include content for which associated tags match the supplied search criteria.