Site Search Using SQL Search

Want to use static pages with "representations" in SQL dbase

[Canton]

Bear with me on this question, as I'm just trying to get my bearings.

I'm building a site that is to have a large number of product pages (possibly over 1 Million).

I'd like to incorporate a "site search" feature (to allow users to search for one or more of those many products) that doesn't involve Perl or CGI. I'm running a Windows box and have a second managed server with both MySQL and MS SQL 2000.

What I'd like to do is have all the pages be static, but to use a SQL search feature to present those pages in product search results.

I'd like to simply make a "record" in the database consist of 4-5 fields from each page (e.g. - title, description, keyword, pricing and, most importantly, the exact URL of static page) so that each record in the database represents one of the static pages.

The search results pages will show the information from the database, including a hyperlink to the URL noted in the given record.

QUESTION 1: Does this approach seem feasible or reasonable?

I know the pages can be made dynamically and that this is an easy and efficient way to create both pages and a search feature, but I'd really like static pages with search functionality.

QUESTION 2: Is there any "out of the box" application/software to help with this?

Thanks in advance,

~Canton