|
From: Garvin H. <squ...@su...> - 2004-10-31 11:02:33
|
Hi Joseph!
> -CREATE {FULLTEXT} INDEX entry_idx on {PREFIX}entries (title,body,extended);
> +#Creating an index on the body and extended body is a bad idea
> +CREATE {FULLTEXT} INDEX entry_idx on {PREFIX}entries (title);
> CREATE INDEX date_idx ON {PREFIX}entries (timestamp);
> CREATE INDEX mod_idx ON {PREFIX}entries (last_modified);
This breaks the fulltext search. Please revert at least for MySQL, don't know
how fulltext search works for PostgreSQL.
Can't PostgreSQL create a bigger index? That sucks! :-)
Regards,
Garvin.
--
Garvin Hicking | Web-Entwickler | Make me happy:
www.supergarv.de | #ICQ 21392242 | http://wishes.garv.info/
|
