Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Re: Slow Slow Slow

Quote Reply
Re: Slow Slow Slow In reply to
Ok.
I added the index into the config, re-ran the nph-setup.

I have two fields indexed. category and story. Only story was previously indexed. Using MYSQLMAN I looked at the table. There is the main database table, story_ndx, and category_ndx (along with the other stuff,log, sessions, users)

story_ndx has every word that was saved into the story field from every record.

category_ndx has only has the one record that I modified since I added the index.

In MYSQMAN, I open the database, then the table, click on properties then index. It creates some sort of index at the bottom of the column listings in a seperate html table at the bottom of the screen, but nothing happens to category_ndx.

Also at this point I cannot search the "category" field at this point.

in the nph-setup - sub create index, it's supposed to create the *_ndx files.

So what did I miss?

Subject Author Views Date
Thread Slow Slow Slow Dan Wheeler 3467 Mar 20, 2001, 1:06 PM
Post Re: Slow Slow Slow
Paul 3397 Mar 20, 2001, 3:25 PM
Thread Re: Slow Slow Slow
Stealth 3413 Mar 20, 2001, 3:35 PM
Thread Re: Slow Slow Slow
Dan Wheeler 3391 Mar 20, 2001, 5:46 PM
Thread Re: Slow Slow Slow
Stealth 3419 Mar 20, 2001, 6:25 PM
Thread Re: Slow Slow Slow
Dan Wheeler 3387 Mar 20, 2001, 6:34 PM
Thread Re: Slow Slow Slow
Stealth 3389 Mar 20, 2001, 6:36 PM
Thread Re: Slow Slow Slow
Dan Wheeler 3380 Mar 20, 2001, 7:08 PM
Post Re: [Dan Wheeler] Slow Slow Slow
needsupport 3268 Feb 17, 2002, 10:37 PM