PHP and Berkeley DB

[JustJon]

My company wants to implement a user search for our website, but we have over a million members, so we need a way to do the search utilizing a way that won't continually be hitting the databases.

What my employers want is to return an exact match (if one exists) and return 20 results that have that string in the name.

A Berkeley db, whose contents would be updated regularly by cronjob, seemed like the best choice, but it doesn't seem to be able to do the latter part of inexact searches.

Is there a way to make use of a Berkeley DB to do this? Or is there a better way to do it?

Thanks.

[badone]

Have a look at sqlite;

sqlite dot org

Cheers,
BAD