in reply to Re^7: Writing a database lookup tool
in thread Writing a database lookup tool
Well, in the post you're replying to, I did give a fairly detailed description of a sample query I had in mind:
"let's assume a there are 15 million records with a 100 characters in each (in the field that we're searching). I look up a 10-character string. There are 1000 hits. How much time would it take for those 1000 hits to be found if the database design and implementation is not particulary well optimized? 0.01 second? 1 second? 5 seconds?"
Finding the records in which a 10-character string occurs in a given field would qualify as a "simple" query, I would think.