|
I think its basically the same kind of system
Here are the tables used:
word -- 121,656 rows -- 8.9 MB
searchindex -- 2,553,167 rows -- 62.6 MB
search -- 2,320 rows -- 1.4 MB
word is where all the words are
searchindex is where all the associations are (ie: 'someword' => post 234098)
search is where the most recent searches are stored.
__________________
Brandon Martus
e-mail
|