would be about just as fast, and you could use a memory
table if you wanted.
- Original Message -
From: Svilen Spasov (Ancient Media) [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, July 13, 2006 9:57 AM
Subject: Re: fulltext search optimization
Thanks for your respond
Thanks for your respond.
Here is the CREATE TABLE:
CREATE TABLE `results_1` (
`id` int(11) NOT NULL auto_increment,
`filename` varchar(255) collate cp1251_bulgarian_ci default NULL,
`fileext` varchar(10) collate cp1251_bulgarian_ci default NULL,
`username` varchar(16) collate
Hello,
I have a website with a MySQL database and I have a table with ~2
millions row (usernames, filenames; ~120MB db data file and ~230MB db
index file) with I would like to search using the fulltext indeces.
Unfortunately the server get loaded pretty much. It always stays on
20 load
Svilen Spasov (Ancient Media) wrote:
Hello,
I have a website with a MySQL database and I have a table with ~2
millions row (usernames, filenames; ~120MB db data file and ~230MB db
index file) with I would like to search using the fulltext indeces.
Unfortunately the server get loaded pretty