Looking at Google Suggest, we'd like to do something similar with a product
catalogue. [type in textbox - matching results come back as your typing]

What would be the best way to cache the results coming back from a SQL 2000
database for optimum performance?

Dealing with obout 40,000 items in the database.

Thought about an indexed binary file, or XML file, cached by the application.