Using Full-text indexes

In MySQL (and MS SQL IIRC) you can create full text indexes
on char,  
varchar and text fields for faster and more advanced
searching  
(relevance calcs, boolean operators, stopwords etc). See
http:// 
dev.mysql.com/doc/refman/5.0/en/fulltext-search.html

Under Postgres, a quick google threw up this quite nasty
module -  
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/

Hmmm.


To improve the searching in phpWebSIte I was thinking of
going to  
full text indexes but it would appear Postgres will throw a
spanner  
in the works.

Anyone got any ideas or will I be doing..

if Mysql { fancy way } else { old way }




Shaun
aegis design - http://www.aegisdesign.c
o.uk
aegis hosting - http://www.aegishosting
.co.uk


------------------------------------------------------------
-------------
Using Tomcat but need to do more? Need to support web
services, security?
Get stuff done quickly with pre-integrated technology to
make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on
Apache Geronimo
http://sel.as-us.falkag.net/
sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Phpwebsite-developers mailing list
Phpwebsite-developerslists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/p
hpwebsite-developers

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Shaun Murray wrote:
> In MySQL (and MS SQL IIRC) you can create full text
indexes on char,  
> varchar and text fields for faster and more advanced
searching  
> (relevance calcs, boolean operators, stopwords etc).
See http:// 
> dev.mysql.com/doc/refman/5.0/en/fulltext-search.html

Note the disclaimer: it can only be used with MyISAM tables.

> Under Postgres, a quick google threw up this quite
nasty module -  
> http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/

Right, because Postgres has a btree index limit of around
2kb (I think).
Tsearch alleviates that problem but its usage, I agree, is a
bit nasty
as it requires a new data type.

> To improve the searching in phpWebSIte I was thinking
of going to  
> full text indexes but it would appear Postgres will
throw a spanner  
> in the works.
> 
> Anyone got any ideas or will I be doing..
> 
> if Mysql { fancy way } else { old way }

I would say "if table type == mysql myisam {fancy way}
else {old way}"
would be preferred 

I think it's great in theory and, if you can check table
type, I say go
ahead and use it at the module level. As for sticking it in
core, I'd
have reservations.

My humble £0.02.

kw
- --
Kevin Wilcox
http://ess.appstate.edu
http://www.appstate.edu
Office: 828.262.6740
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.6 (GNU/Linux)

iD8DBQFFLPSKsKMTOtQ3fKERAvnKAKCgcb7wDMCKCM1uKua9wgSPYy9g3ACf
YUZD
K31HjSGpNTB/rMX6/jQDrvw=
=hyBI
-----END PGP SIGNATURE-----

------------------------------------------------------------
-------------
Using Tomcat but need to do more? Need to support web
services, security?
Get stuff done quickly with pre-integrated technology to
make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on
Apache Geronimo
http://sel.as-us.falkag.net/
sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Phpwebsite-developers mailing list
Phpwebsite-developerslists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/p
hpwebsite-developers