Another milestone on my search project.
I’ve figured out some complicated items on search queries and how to handle them using forward indexes. I don’t have them implemented on the main page yet, but experimenting around I am now able to handle single word searches, multiple word searches and search phrases using the forward indexing.
There is still a long way to go yet. Multiple phrases and boolean expressions are not yet handled. Yet at the same time the queries now take 1/10 the time they used to.
http://rwack.com (It also wouldn’t hurt if an ad or two was clicked 
)
There are also some things I need to implement which require I start over on the database so I get to wipe it out and start over.