Hello

having a problem indixing the database..

It was working fine up to few days ago.. and now when I index I get

Done! right away..

and the new links validated are not searchable..

any ideas?
Regards
KaTaBd

Users plug In - Multi Search And Remote Search plug in - WebRing plug in - Muslims Directory

I am also having indexing issues... what indexing method are you using (ie MySQL, Internal)?

Hi

I am using MySQL
Regards
KaTaBd

Users plug In - Multi Search And Remote Search plug in - WebRing plug in - Muslims Directory

Could there be a bug with the MySQL indexing I wonder?

(Jack is looking into this for me, I have sent a support request in.)

Does your search return any results at all?

I do get results but the results do not include the resent additions or changes.
Regards
KaTaBd

Users plug In - Multi Search And Remote Search plug in - WebRing plug in - Muslims Directory

It isn't a bug, basically mysql indexing is crap :)

....the new version should be improved.

http://www.gossamer-threads.com/...orum.cgi?post=190418

Replied here.

BTW, I agree with you about MySQL indexing.... until I see otherwise anyways!

This is normal for the MySQL indexing scheme. MySQL maintains it's own index tables, so Links SQL does not ever "re-index" them like it does with the INTERNAL indexing scheme.

If you are not getting any results, check:

1. MySQL does not allow you to search on words less then 4 characters.
2. If a word is very common (in more then 30% of records I think), it will show no results (Links SQL can determine a common word from a word that does not exist as the MySQL indexing scheme does not tell you this).

Cheers,

Alex
--
Gossamer Threads Inc.

>>1. MySQL does not allow you to search on words less then 4 characters. <<

From mysql.com:
Any ``word'' that is present in the stopword list or is just too short (3 characters or less) is ignored.

>>If a word is very common (in more then 30% of records I think), <<

Its 50% I think.

http://www.mysql.com/...ext_Fine-tuning.html

3 characters or less == less then 4 characters. =)

The docs represent 4.0, not sure how much they apply to 3.23, but it may well be 50%.

Cheers,

Alex
--
Gossamer Threads Inc.

My brain couldn't cope with seeing the number 4 and overloaded

(Or perhaps I didn't read your post thoroughly)