What is the fatest way for searching for a database with million of records?
I have two goals:
Code:rs.open "select count(*) as keywords.word from keywords WHERE keywords.Word IN (select economics.bodytext from economics where economics.indexid = keywords.indexid) and keywords.Word IN ('" & StrKeyword & "')) ", conn
1. Not a list of keywords found at economics.bodytext, but the keyword found together their frequency.
2. The images of the database
3. The url que inspirated me to do that program:
It is impressive the speed of their search!