Scalability Performance - Thousands of entries

Random stuff about serendipity. Discussion, Questions, Paraphernalia.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: tired_one - Garvin - Tom - tnx

Post by garvinhicking »

Steve, yeah - the upgrade to .8 should fix that. You can, of course, already now write a simple PHP/MySQL script to fix the index keys on all of your tables, which I'd recommend.

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
tired_one
Regular
Posts: 25
Joined: Thu Jan 13, 2005 11:51 pm
Location: USA

Post by tired_one »

Code: Select all

create fulltext index entry_idx on serendipity_entries (title, body, extended);
just replace the serendipity_ with whatever your table prefix is.
-Robyn
Post Reply