in reply to Novell NetWare perl reading DBF's.
If so, I would definitely prepare a query in Perl and let the database handle it. It ought to be optimized for that sort of thing.
Regardless, there are a few places where you have things inside a loop that don't seem to need to be there. Case in point, checking the query for a certain type, then choosing which keywords to find. Unless the query changes in the middle of the search, you can compute the search elements just once, not once for each row of the database.
|
|---|