Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

Indexing question...

Jan 1, 2002, 2:50 PM
Dinky
User (354 posts)
Dinky's avatar
Jan 1, 2002, 2:50 PM
Post #1 of 4
Views: 1189
Shortcut
Quote Reply
Indexing question...
What exactly is the difference between INTERNAL, INDEXED, NOINDEXED, MYSQL, and so on when indexing your databases, and which one would be best for large databases such as a Dmoz import??

</not a clue>
Jan 1, 2002, 2:54 PM
pugdog
Veteran / Moderator (6956 posts)
Jan 1, 2002, 2:54 PM
Post #2 of 4
Views: 1158
Shortcut
Quote Reply
Re: [Kilroy] Indexing question... In reply to
Alex posted this awhile back:

Quote:
We have added different indexing schemes to 2.1.0. Currently it supports:

INTERNAL - The old style indexed searches
NONINDEXED - The old style non indexed searches
MYSQL - uses MySQL's built in full text indexes
MSSQL - use MS SQL's built in full text indexes.

I'm disapointed in MySQL's, as the search results aren't too great, but I must say MSSQL's full text indexes are great. They are very fast and do quite a good job at getting results.

You can change this in Database->Links->Properties.

Cheers,

Alex





PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.
Jan 1, 2002, 3:49 PM
Dinky
User (354 posts)
Dinky's avatar
Jan 1, 2002, 3:49 PM
Post #3 of 4
Views: 1150
Shortcut
Quote Reply
Re: [pugdog] Indexing question... In reply to
Can you use the mssql indexing on a mysql database?

</not a clue>
Jan 1, 2002, 4:00 PM
Paul
Veteran (19537 posts)
Jan 1, 2002, 4:00 PM
Post #4 of 4
Views: 1151
Shortcut
Quote Reply
Re: [Kilroy] Indexing question... In reply to
MS SQL indexes are for MS SQL, MYSQL indexes are for MYSQL Cool