Computer Learning Zone CLZ Access Excel Word Windows

The less employees know about the cash flow, the smaller the share they can demand.

-291st Rule of Acquisition
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to General Discussion Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
New Search Index on Site
Richard Rost 
          
9 months ago
Over the past couple of days, I've been spending some of my free time building a real search index for the site. Until now, if you searched for something, you'd only get results if your "exact phrase" matched something I had manually added to my hand-built index of popular tips and titles. Or you might get a hit if the words appeared in exactly the same order you typed them somewhere on a page or in a comment.

The new search index changes that. It's more like a Google-style engine that breaks down every page and every comment into individual words. Now, if you type in three words, you'll see results as long as all three words appear somewhere in the same page or comment - even if they aren't right next to each other. It's still strict in one sense: if you type five words, then all five need to be present for a match. But at least you no longer need the exact phrase, which is already a big step up.

Next on my list is to loosen that rule so you won't need all of the words. Maybe four out of five will be enough, which should make the results more flexible. That's coming soon. For now, the indexer is still chugging away in the background, working through nearly 20 years of pages and comments. After just a couple of days it's already over 100,000 records, and it's indexing newest-to-oldest, so the most recent material will show up first.

So give it a try. Play around with it. Let me know how it works for you and what you'd like to see improved. I'm having fun learning about search engine design, and I'd love your feedback.

And yes, eventually this will probably become a database lesson of some kind. LOL

LLAP
RR
Kevin Yip  @Reply  
     
9 months ago
Eventually you may have to really on AI to help you with that.  The greater the amount of text, the greater the need for advanced search algorithms, and your site is huge.  There may be misspelled words, alternate spellings, word conjugations, contractions, dialectic phrases, etc., that can't be handled with traditional search methods.
Richard Rost OP  @Reply  
          
9 months ago
Yeah, I'm taking it step by step. I'm starting off with just basic keyword indexing. Then I'm going to add help with synonyms and stuff like that. I want to get it as good as I can with just traditional algorithms, because I don't want to rely on AI API calls every time someone wants to search for something.

So there is already an AI search bot that's been programmed with the outlines for my courses and the tech help videos. It's not perfect, but it's got a lot in it. So I might eventually merge them, but we'll see. It's still a work in progress. It's when I get some free time. And there's always the option to Google Search. If you scroll all the way to the bottom of my search page, there's a link there that will do a Google search on my site, which I sometimes have to rely on myself.
Richard Rost OP  @Reply  
          
9 months ago
Well, after the indexer ran for about 24 hours, it indexed about half the pages on the site and about 1% of the comments (those will take a while), but I had to restart it. I did some quality testing, and I realized that I didn't factor apostrophes into the tokenizer, so it was breaking up "ain't" or "can't" into two separate words, "can" and "t". I'm not indexing words under 4 characters long because they typically don't produce good results anyways. So I had to clear the indexed flag from all the pages, then let it run again.

I kept all the data that's in the indexing table, so it's all still in there, but I cleared the indexed y/n field from all of the page entries and all the comments, so it'll just look like none of them have been indexed. It's going to slowly re-go through all of them and re-index them again. So pay no attention to those percentages for now.

But like I said, it's a work in progress. I went to search for my "Null Ain't Null" video just by using the word "ain't" and I couldn't find it, and that's when I realized there was a problem.

And in a few minutes, after this comment is indexed, it should show up too. Yay.
Richard Rost OP  @Reply  
          
9 months ago
And yes... it did. :)

This thread is now CLOSED. If you wish to comment, start a NEW discussion in General Discussion Forum.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 6/14/2026 4:43:53 AM. PLT: 1s