Re: [pLog-General] Searching...

[Oscar R. <os...@re...>]

Yes, you are right... it also works in 3.x but according to what I've 
read so far, 3.x doesn't support boolean operators (I don't know to 
which extent those are supported in 4.x either) and it performs far 
slower than 4.x specially when creating indexes. But despite that, I am 
starting to like the idea of using MySQL to take care of that and 
forget about complex inverted indexes tables, accuracy rates, etc.

By the way, speaking of accuracy rates, if only we could figure out how 
MySQL comes up with the relevance/accuracy ratios that it assigns to 
each match...

I also found this long thread in the sitepoint.com forums that gives 
some figures about the speed, size of the database, etc:

http://www.sitepoint.com/forums/showthread.php?threadid=69555

Worth having a look at it.

Regards,

Oscar.

On 5 Feb 2004, at 04:29, Matt wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Wed, 4 Feb 2004 19:09:52 +0200, Oscar Renalias <os...@re...>
> wrote:
>
>> The good thing about this is that we wouldn't have to do anything,
> in
>> the sense of implementing/developing a search engine. But of course
> if
>> nobody's going to be able to use it because it needs mysql 4.x,
> then
>> it's a little bit pointless...
>>
>> We could also do some research about searching and indexing
> techniques.
>> Does anybody know good resources about that? Sites, white papers or
> even
>> books?
>>
>> Oscar.
>
> Ah my post before shows how to do it in mysql 3.23 (if no-one noticed
> the 'status' call at the end of the shell dump...)
>
> - --
> Matt C.E. Wood			|
> wo...@wo...			|  PGP Public Key.
> wo...@cc...		|  http://woodzy.com/woodzy.asc
> Ham Radio: KF4TBH             |
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.1 (MingW32) - WinPT 0.7.96rc1
>
> iD8DBQFAIapvIATdTQnsQScRAlUdAKCn8wsxXJi8wz43JgpZNCKvhJsA2wCgviG9
> zt0LIBKgEZWKWLpDbm7/HaI=
> =FMqj
> -----END PGP SIGNATURE-----
>
>
> -------------------------------------------------------
> The SF.Net email is sponsored by EclipseCon 2004
> Premiere Conference on Open Tools Development and Integration
> See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
> http://www.eclipsecon.org/osdn
> _______________________________________________
> pLog-General mailing list
> pLo...@li...
> https://lists.sourceforge.net/lists/listinfo/plog-general
>