Hi,

If hardware is not an issue, I would recommend:

1. Fast SCSI drives
2. Latest MySQL
3. Enough memory to fit entire database into memory (1 Gig plus)
4. mod_perl

Try Links SQL under those conditions and you'll find almost all searches come back in under 0.1 seconds. Of course, if you are looking for a custom solution, you can always contact us through the site.

Cheers,

Alex

--
Gossamer Threads Inc.