|
I don't think you can carry this is of cheaply.
I'm beginning to see problems with fulltext searching through 120k rows. But then thats with a search per second or so.
You will need enough mem to keep the index in memory otherwise you are toast.
You probably must go with a FULLTEXT index, wildcard searching will be too slow.
|