GoFuckYourself.com - Adult Webmaster Forum - View Single Post - MYSQL: wildcard search through 40 million records.

mrthumbs · 03-07-2003, 01:21 PM

A record consists of 1 to 50 characters.

What hardware requirements do you recommend and what's the time-frame we are talking about to perform one search?

(should be about 6k to 15k searches per day)

Any cache modules or non-mysql methods available that are faster since the records are static?
It's for simple wildcard keyword-match searching.

03-07-2003, 01:21 PM
mrthumbs salad tossing sig guy Join Date: Apr 2002 Location: mrthumbs*gmail.com Posts: 11,702	MYSQL: wildcard search through 40 million records. A record consists of 1 to 50 characters. What hardware requirements do you recommend and what's the time-frame we are talking about to perform one search? (should be about 6k to 15k searches per day) Any cache modules or non-mysql methods available that are faster since the records are static? It's for simple wildcard keyword-match searching. Last edited by mrthumbs; 03-07-2003 at 01:26 PM..